This isn't really "niche", but
Hades: The Nine Stages Of Change At The Deceased Remains by My Dead Girlfriend was the album that convinced me to start listening to albums in their entirety with the proper track order, and made me realize how important even the order of the tracks in an album is.
Weirdly, that was not something I ever did before listening to that album for the first time, I was always the type to just listen to songs individually outside of their proper context. A product of primarily only listening to game soundtracks and openings/endings to shows I liked when I was a kid.
I liked the way it told a story that progressed with each track (the first track being the "Prologue" to the Nine Stages of Change, it being a relatively upbeat song with a kind of melancholy undertone to it, then progressing with nine other tracks, with the 10th track being the ninth and "final" Stage of Change and being an outwardly depressing-sounding song about losing someone while you're still alive)
It helps that the story being told also really got to me, This might be the only album I wish I could listen to for the first time again. That first experience of listening to it in the afternoon, dozing off underneath my window while basking in the sunlight, and then waking up as the final song closed out with the sky getting dark as it got late is something I don't think I'll ever be able to experience again.
So now, whenever I find out about a band I hadn't heard of before, or when I'm listening to an album for the first time, I try to listen to it all the way through without skipping songs.
Some other albums I like that kind of progress a story with each track are Eyedea and Abilities - First Born, Senses Fail - Still Searching, and siinamota - Yume no Manimani