If you want sad indie rock tunes get XO or Roman Candle by Elliott Smith. Both records are chalked full of them. Condor Avenue and I Didn’t Understand (though that one in particular may not be the vibe you’re looking for) is particularly gut wrenching.
***********************
Also, you’ll either love it or hate it, but Ween does a really sad song called Birthday Boy.