Suicidal Sam
Looking for a fic on ff.net. It's right after Sam finds out he is Lucifer's vessel and after the phone call to Dean. I think Dean comes to find Sam at his hotel ands finds that Sam killed himself by a gunshot wound to the head. As Dean holds Sam in his arms Sam starts to heal and comes back to life.