You including SACD in that pal?
They probably fall under the CD category, but yes, I'm aware I'm ignoring BluRay Audio, MiniDisc, DAT, 8-track, reel-to-reel, all of which are still being released to varying degrees by niche labels. In terms of your 'main' formats, though, vinyl is less popular than download, CD and streaming, which means the amount of press it gets is a bit daft.
In terms of tapes, if you get a well mastered, well dubbed tape (ideally on chrome), played on a high quality deck, it sounds absolutely great. The thing of tapes sounding shit (and I've seen them described as both tinny and muddy, so... eh?) comes from them often being played on cheap walkmans and boomboxes. They won't reach vinyl standards of fidelity, but I recently recorded an album I was working on to my parents' twin cassette deck to get a lo-fi tape sound (as I've done in the past to a £35 portable stereo), and when I recorded it back to digital the difference was very subtle. A minuscule amount of hiss, but otherwise they were pretty much the same.
There's certainly very little benefit over buying a CD, in terms of listening (the ability to stop the tape and return to exactly the same point aside, as
thenoise mentions above), so I think when it comes to bigger releases, a lot of tapes
are bought as novelty items, especially as they're usually about the same price as CDs these days. But if it's a tape-only release, or maybe tape and vinyl and you're on a sensible music budget, then they're perfectly fine as a way to listen to music, unless you're a genuine audiophile.