For FPS games I could imagine it would make life harder, rather than more fun. Watching that HL2 video shows it seems quite hard to control. But for other uses I imagine it could be nice to use as it does give full mouse control so might be good for things like media player control.