I prefer 60FPS and always tweak as much as possible to get it, I even have a tag that says 60FPS+ on Darkadia so I can keep track of what games actually can run it (mostly about the game, not because of my computer). That said it depends on the game and its engine and my mood. I've no problems playing Heroes III (one of my favourites) which run at 10FPS constantly but animations are very stiff in that game, it's likely that and because I played it since I was 10 years old. Heroes IV on the other hand where movements became more 3D it bothers me more but it's still playable. I still prefer 60FPS and I'm willing to lower all graphics except resolution if the game supports 1080p, if it still runs lower than 30FPS I put the game into my backlog and wait for an upgrade.
I agree that consistent framerates is as important as high framerates, that's why I always recommend frame limiters and VSync. No point going over your monitor's hertz setting.
Arkenbon: Edit: Also for consideration:
15 FPS vs. 30 FPS vs. 60 FPS
http://boallen.com/fps-compare.html It's a useful site but I find doing tests on that one becomes inconsistent. I notice framerate drops much quicker in games than that site.