Actually, coming back to this comment reminded me of another fic: Scheherazade of the Super Eight (http://pyrebi.livejournal.com/38205.html). It's gen s6 with Dean and Cas as the main players. It's good and Dean being dead is kinda central to the story, though I'd kinda forgotten about the dead part myself, lol.
Summary: Dean doesn't know why angels keep recruiting him for impossible tasks. But they do, and now he's apparently the last chance heaven has--not only against Raphael, but against a dangerously unhinged Castiel. Oh yeah, and he has to do it all from the confines of a 10'x16' motel room that doesn't even exist.