My answer is a pretty obvious one: San Francisco
Though I do have a car I use it very rarely and rely on public transportation quite a bit. It's not perfect - trains and buses can be late or take a bit longer than expected - but I'd say it's decent. The city is also perfect for whatever socializing and shopping you're into - there really is something for everyone.
I hope you get some more answers with other interesting locations!