Ghost (1990)

And so the story goes .. that's the way many stories end. But not this one and this is the way I like to tell it -

Hot shot New York banker, Sam Wheat (Patrick Swayze) and the beautiful Molly (Demi Moore), a sculptor and avant garde are a couple very much in love. Theirs is a romance we all dream of having but this love story is wrought with tragedy. Sam is killed in what is believed to be a mugging and the only way to prove otherwise isn't as simple as all that. Playing detective is Sam's ghost but not alone. He seeks the help of a much sought after psychic, Oda Mae Brown (Whoopi Goldberg). Here unravels a tale of love, treachery, motivated by greed and then culminates with sweet revenge.
Always a favorite with me and if I need a good boo-hoo, it's on, period!

And with goose-bumps and all The Righteous Brothers (1965) - Unchained Melody