No twitch FPS gamer will ever limit his/her framerate, unless he.she is a total idiot.
Personally, I find tearing extremely distractive. My solution to the issue you describe? Fire up my trusty CRT which does 1024x768@120Hz, modify the game to process at 120fps (if it offers such an option) and enable vsync. Same result, only without visual artifacts from viewing two frames on screen at the same time.
Yes, that would put me in a disadvantage in Q3 but I never liked that game, so...
@yotambien: am I the only one who prefers old-school stop-motion animation? Your video is actually pretty impressive, but somehow I find the jerky animation of stop-motion adds to the tenseness of the scene. Or maybe I've seen too many horror films from the '60s, I don't know.