I believe that is Silent Scope, most notable for a bloody huge sniper rifle lightgun pointed at the screen.