Hmm,
Where All the Ghosts Play makes a nice companion piece to
sgt_psycho's most recent fic that I just recced. It's a Skin coda from Sammy's POV. The brothers are together and all is right with the world. Everything except the reports of missing girls. The characterizations are perfect and prose sucks you in.
kho has written a very powerful introspective Sam piece,
A Life Without Choices. I'm amazed that this was written based on a single episode, and yet it still rings incredibly true to Sam's character -- I'm not sure if that reflects more on Kripke or kho, but I don't really care. It'll have you hurting all over again for Sam just like the end of the pilot did.
In case you need your heart broken with a scene from Sam and Dean's childhood,
mahaliem obliges with
Night Rituals. It's short and heartbreaking and probably all too true to canon.
It's rare to find a happy fic in the SN fandom I think.
Painted on Jeans by
bkm5191 comes close, but really lands you on the teary side of nostalgia. John checks up on Sam and seeing Jesse reminds John of when he met Mary. There's some typos and such, but the emotion behind the writing makes it easy to ignore.