One case not mentioned here is families with small children. With 3 little ones, public transportation becomes a real hassle, especially when there is walking to be done on either side. It is by far my top reason for owning a car in the city.
I also don't want to be against a grocery store as the noise from the large parking lot (and busy road) is annoying. Living by a park is highly desirable.
We're protected from the busy road and the grocery store parking lot by elevation; we're 50 ft below either. We can hear the highway, but I only notice it when the din is missing when we visit friends in the country!