Try every song on “Whatever and Ever, Amen” and “The Unauthorised Biography of Reinhold Messner” by Ben Folds Five. The first album is more bouncy, the second is somewhat darker, but they’re both great.
There’s a sublime song on the Concrete Blonde album “Mexican Moon” called “Love is a Blind Ambition” with absolutely gorgeous paino. It’s very sparse, with bare guitar and soaring vocals, and a long piano fade-out that never fails to move me. (The same album has “Close to Home”, which also features some beautiful piano - the instrumental break is like a soaring duel between the piano and the guitar.)
“Correspondedces” by The Tea Party, from the album “The Edges of Twilight”. But be careful it doesn’t rip your heart right out of your chest.
There’s always Nick Cave and the Bad Seeds, although he’s not to everyone’s taste. Good albums to check out would be “The Good Son”, the “Best of” collection and his new album “No More Shall We Part”. Fave songs of mine are “The Ship Song”, “Where the Wild Roses Grow”, “Lucy”, “The Mercy Seat”, “Red Right Hand” and “As I Sat Sadly By Her Side”.
An Australian band called The Whitlams does loads of great piano songs. If you can find it, check out an album called “Eternal Nightcap”. The song “No Aphrodisiac” is one of my all-time favourites, and it’s about as emotional as a song can get. There’s also the cracking “You Sound Like Louis Burdett”.
I have a version of “What’s Up?” by 4 Non Blondes (a b-side to the original single) done on piano. It slays me. But it’s probably very hard to get.
For something a bit different, try “Sunburn” by Muse.
I do love a good bit of piano in a rock song.
[sub][sup]There’s no aphrodisiac like loneliness
Truth, beauty, and a picture of you…[/sup][/sub]