This was definitely on Archive of our Own. Basically, Sam is suicidal, but can't flat out kill himself (duty to his family, maybe?), and instead, while going around checking the salt lines, etc., he prays to god, or a deity or an angel or someone to have a monster come and kill him. Dean overhears him praying, and they get all emotional and comforty and stuff.
Thank you!