I'd argue that most cars today are far over-tired for fun driving on the street. Sure, slot car handling is great for winning races, but for just having fun on a public road, why not have less tire so you can play closer to the limits without going way beyond the speed limits?
One of the best street driving experiences I've had, was my 95 Neon on sandy wet twisty roads up in cottage country, on 155/80R13 snow tires. Hardly got to 50mph but you could use all the grip available without too much risk, and the soft gravel shoulder offered almost as much grip as bit of a safety margin(not that I used it).
In autocross, it is possible to over-tire a car as well, and if you go too wide, the car actually gets slower in many cases. You start to loose steering feel as well with an overly wide tire. 205/50R15's was the biggest R-comp I ran on the Neon and I appreciated the raw grip for climbing up the result sheet, but I think the car was the most fun on 195/60R13 performance street tires. It was just more precise and it was easier to get the car to do what you wanted.