Song of the Reaper (http://jenshih-blue.livejournal.com/240765.html) by jenshih_blue comes to mind: "Private detective Jensen Ackles is a cynic and believes he’s seen the worst humanity has to offer until one night a dark haired beauty by the name of Genevieve walks into his office. The job, discover the truth behind the death of her fiancé Jared Padalecki, a local artist. The cops have labeled it a suicide, case closed, but she refuses to believe it. As Jensen digs into her fiancés mysterious past, he finds himself drawn into a world darker than he imagined, a world leading to a path of emotional self-destruction. After all—how can you fall in love with a dead man?" It doesn't fit exactly, and there are lots of warnings to heed, but it's a great story.

Another one that doesn't really fit the prompt at all but that you might like anyway is Lady Divine (http://story-monger.livejournal.com/16748.html) by story_monger: "Mary finally has the life she wanted. A loving husband, a son, and a second child on the way. The last thing she needs is anything to do with the supernatural. Then a series of mysterious deaths occur too close for comfort, and Mary starts to realize that her past isn't as far behind her as she thought." It's gen (or Mary/John, sort of), and tells the story of how Mary became the ghost the boys find later.

*looking sheepish* I'm not really a fan of gen fics, but I will give this one a go. The first one looks really interesting though. Thanks!

Awww, don't be sheepish! We all have our preferences. :) I generally read slash myself.

How about linvro21's The Strange Affair Of The Ghost On Franklin Street (http://linvro21.livejournal.com/24571.html)

Summary: Jared and Jensen are Private Investigators working on the same case out of the same office. The problem is that Jared lives in 2013 and Jensen died back in 1947.

I have already read this! Thanks for reminding me, and you're right, it is a great story!

There's a story by cherie_morte called Behold, A Pale Horse (http://infatuated-ink.livejournal.com/92188.html) that would fit your criteria nicely. Have your tissue ready.

Oh god, I read the summary and I'm already crying. Thanks for the rec!

I remember 'The Empty Room' I believe by germanjj possibly, it was among the early bigbang years, 2011 maybe?... sorry, I can't find a link right now but you should be able to find it in the masterlists, it was J2 iirc. Here's the link: http://germanjj.livejournal.com/31659.html

You can also try the Ghost-category on spnnightcrawler it has all kinds of ghost-fic, but the summaries should help you find something that fits your bill!

Edited 2015-01-13 09:14 pm (UTC)

Oh gosh yes, how I could forget about spnnightcrawler! Silly me! And I think I've already read The Empty Room ages ago...won't hurt to read it again though. Thanks!

You're very welcome, I hope you find fic to your heart's content!

And, just read this one. It's gorgeous.

Hello (http://archiveofourown.org/works/2121138/chapters/4628868) by askance: "There's a woman at the grocery store named Evelyn who always rings him up on the days he ventures out for food and she knows him, or likes to think she does. I hope you're not too lonely, she'll say. He chooses not to tell her that his dead brother sleeps at his feet every night. He'd rather not be the cause of her inevitable heart attack." (Sam/Dean)

Oh my god, that was perfect!! I totally cried a little at the end (even though it wasn't a sad ending).

You might enjoy Giving Up The Ghost by dimpleforyourthoughts. I'm having trouble linking to it, but it's on AO3 and easily searchable. :)

Here's the link :)
http://archiveofourown.org/works/2129613/chapters/4649682

In this one, Dean is temporarily noncorporeal and it's absolutely excellent. One of my favorite wincest fics, period.
http://infatuated-ink.livejournal.com/67166.html