My limit in a new car would be 8 seconds, and that's a hard limit. Six starts to feel pretty sporty. Four is defintely getting there and traction limited usually.
To get under 3 pretty much requires AWD or a rear engine.
For me, I want responsiveness, which usually means going 40-65 pretty effortlessly.