I hear that. I had a number of friends who had them in their cars. However, I found the rotary models to be the best, and they always had to go in the trunk. All the in-dash players in cars I've owned all scratched the crap out of my CDs. What I loved about tapes was that they were less bulky and I could dub anything onto them from any source. Certainly they weren't without flaws, but I had very few problems with them.
At any rate, the good CD changers were cool, for sure. My friend had a fancy one in the trunk of his car with a massive Rockford Fosgate system in the trunk. That was pretty hip.
I had a Honda Civic in the late 90s with a killer stereo. I swapped the stock unit out for an Alpine CD player, then added an Alpine 6 disc changer plus a 12" sub and amp in the trunk. I'd load the changer based on what I felt like listening to that week.
Once music became files instead of physical, my listening habits changed. Scrolling through my entire library at once became overwhelming, so I largely stopped listening to music in my car. Now, it's mostly podcasts. Which I don't need a fancy stereo to enjoy. My current car doesn't even have a CD player.