Going back further, to the 2D consoles, it was almost never a problem. The Bitmap Bros games (Gods, Speedball, Chaos Engine) didn't run at 60fps but were still perfectly playable, and those are the only ones I can remember at this stage that didn't run at 60. Everything else was just pretty much deadsmooth at the time.
Enter 3D hardware and everything started going jerk jerk. And we haven't progressed much, most PS3/X360 games struggle to keep up 30fps without screen tearing or dropping frames.
Luckily most Wii games run at full frame rate but I wonder if we've seen the last console where majority of games run at 60?
And agreed, Perfect Dark 64 became pretty unplayable in the later stages. Playing it on XBLA at a solid 60 was like a breath of fresh air.