I'm not going to pretend this is a top 10 ranking, just a few that occur to me.
One I think is hugely underrated is Sixpence None the Richer's eponymous album from the 90s. It's the one with "Kiss Me" on it, that you'll hear playing in grocery stores all the time. "Kiss Me" by itself can come across as schmaltzy and saccharine (although IMO it just treads that line without ever crossing it, redeeming itself by being shockingly earnest and sincere). The album as a whole, though, is moody and evocative and wrestles with dark emotions. Listened to in its album context - which people still did in the 90s, before streaming - Kiss Me bursts out of a milieu of depression and exhaustion with exhilarating energy - that doesn't last, and then has to be processed through more ragged meditation before the listener arrives at some sort of resolution by the end.
It's really a whole-album experience, but this is my favorite track from it. Bear in mind that Kiss Me was track 4; listening through the album in sequence, this is where they've brought you by track 11. There's been darker stuff in between, and the album's second love song is so different in tone from its first:
Another, more recent, is Samantha Fish's Belle of the West album. She had made a splash as a blues guitarist, and honestly I felt a lot of dread when I heard her next release would have a more country/Americana vibe. It also apparently included a lot of material that had been left on the cutting room floor from sessions for the Wild Heart album, but in my opinion this is some of her best songwriting. There's a whole album at this level.
Third would be to dip back, and go to Yes. Hard to pick which one, but I'd probably have to say Close to the Edge. Y'all know it, I don't have to share a track to sample it here.