"Especially in competitive gaming, I often see people targeting frame rates way beyond their display’s refresh rate. I’m not sure whether this actually provides a real benefit or whether they’re chasing a placebo effect."

Depends on the engine. Anyone remember Quake 3's multiple of 3 frame rate speed hack?