I drive no more than once or twice a month, to get to the coast or the mountains (or all of Europe via ferry/tunnel) or to move heavy stuff around. It didn’t cost me much but it’s reasonably fast and a joy to drive on country roads.
I can’t think of anything worse than having to drive every or even most days, to work or the shops or to see friends.
I walk almost everywhere, cycle most of the rest, take public transport if it’s really raining or really far (or I am late) and take the occasional Uber when none of those is an option and I still don’t want to drive.
So I don’t think there should be no cars, just [almost] no cars in the middle of most cities and towns, and no need for anyone, anywhere to own one to have a reasonable life.
However, I also don't really want to use my car every single day to commute, or do basic chores. I see my car as an exploration/recreation/hobby, and I love it! But do wish that it wasn't necessary for the more boring parts of life, too.
I'm in central Texas and cars are somewhat necessary because of weather. Not enough businesses have employee showers, so biking or walking is often not a realistic option.
I also think if real self-driving cars are developed, it's going to fuel sprawl like nothing before. We will look back on cities of today and think they were decently dense.
These days, I'm pretty much in the pro-car camp. In my 20's I didn't like them and chose to live in pretty small places as close to the heart of the city as I could and I got by with a bicycle and small motorcycle. Then I had kids and we moved to the 'burbs for all the usual reasons. Now that my kids are at college I think my wife and I would like to move further out of the city where we can have a smallish house with enough land for things like a big workshop, greenhouse, gym, sauna, etc... When we get old enough that we aren't as engaged with our hobbies, maybe we would head back into the city for the closing chapter of our lives. I don't think that type of arc is all that unusual. People want different things in different parts of their life.