Currently there is one Nvidia GS 790 card installed.
Maybe you mean Nvidia 7900 GS?
It's a pretty good card for a desktop and shouldn't be having any problems with adventure games unless they're driver-related.
Do you play Action and RPG games or only Adventure games?
With a 750 Watt power supply, your computer should be able to support nearly any video card. But if all you play is adventure games you don't need an $800 video card that plays the latest FPS at 1920x1200 resolution.