I usually have fun looking forward to driving a longer distance. Once I am in the car, stuck in the usual jam while trying to leave the city, the fun is gone. And it doesn't come back when the road finally gets empty late in the evening.
I used to own a convertible. It was fun using it on summer evenings and nights, in the countryside.
Take a look at the rear seats of executive towncars, for examples of this kind of thing. People who can be driven everywhere in their own cars will go to substantial lengths to get them just the way they like them, whether that's for working, entertainment, napping, or whatever else.
There is no Uber. Taxis are expensive and unreliable. It's too cold to run or bike most of the year. Everyone owns cars or has someone who does drive them around.
These articles always love to talk about Uber and public transit as eating away at the car market... But outside of the major centers where people are writing these articles, the car is still often king.
It is usually faster (some metros excepted) and usually more reliable, but people seem to consistently underestimate how much they spend on their cars. If you live in a major metro area (not its suburbs) my guess is that public transit is usually much cheaper. It certainly is in the ones I have lived in. If you've got a decent transit system (and that's a big if in North America), of course.
On the other hand, there are plenty of living arrangements that make transit impractical.
But as you wrote, these values vary very much depending on your location.
There are more uses for cars than A to B devices. Watch this video. I saw it when I was around age 16 and it's stuck with me ever since.
And yeah, I drive in a large-ish city. Still enjoy the experience. Most of the time don't even have the radio on, just listen to the engine rumbling.
But maybe the lack of these in public transportation is simply because they can be found elsewhere, I.e. a demand issue that would be solved naturally.
The only thing I think will make it worth while is this: I drove the car (I drove!) to my destination, get out and then I can tell the car: 'find a parking'.
Owning a car stopped being fun 20 years ago (at least). Today, in a big city, it only enhances the stress level. So as a consequence it makes sense not to own one (let alone the costs). And it also makes sense that people buy vintage cars. This can be fun, if you like to tinker and don't have to rely on this thing to bring you somewhere and in time.