Game to improve USPSA/IDPA Shooting

[Ian]

Hello.
This is my first visit here.
About 6 years ago, I played a very good game (maybe Play station) where you hold a plastic pistol in your hand, and shoot targets as they appear on TV screen.
My wife wants to buy me a Play station/X box for my birthday.
Could you please tell us what system would be better, and recommend the best game for this purpose?
We both shoot competitively, and I am sure this would be good practice for us, as well as loads of fun.

[kswiss2783]

Duck Hunt for NES!

[Ian]

This game was very exciting, moving through buildings shooting bad guys, some with hostages, very realistic.

[AC37]

There's Virtua Cop and tons of other similarly-veined games.

[GroovedG19]

You possibly could be talking about Time Crisis.

[Ian]

Yes, that looks like the game.
Thanks GroovedG19.
How does the latest version compare to any other games for Play Station, specifically for improving shooting skills, in your opinion?
Does it come with a handgun and/or long gun?