I own an old Accord I inherited from my grandmother after she passed away. I keep it well-maintained but I don't drive it a lot (6,000 km a year?).
I'm in a suburb of Vancouver, but I have only a 20 min bus ride to work, and I have both an express bus and Skytrain to get downtown.
I have a bank, drug store and grocery store less than 5 min walk from my place. I bike to the gym and do almost all of my runs from my place.
I usually drive to visit my parents (30 km away). It is possible on transit (did it last winter when there was too much snow to drive) although it takes longer.
I can recall a few day trips for hiking where my friends and I had to drive (no transit access), but apart from that, I imagine I could do pretty well without a car for the most part. Traveling throughout a number of major European cities, I used transit as I didn't have a car there, and I actually found it pretty convenient and relaxing. Traffic congestion pisses me off, and I think my mental health and stress levels are better off by driving less.
If car-sharing were expanded outside of Vancouver proper (I think there are only 2 shared vehicles available in Burnaby), I'd consider getting rid of my car entirely and just getting a membership to supplement transit.