My experience is that everybody (where everybody is defined as a significant majority but not everyone) tends to be at least fairly negative about public transportation that they're forced to use day in and day out. I could name a number of cities that I consider to have pretty good transit if you're going from the right point A to the right point B where I could still imagine it being pretty tiresome using it all the time for a variety of reasons.