i think it's vgs that runs the games, and not the other way around.
but usually VGS has a very high rate of compatibility with RPGs. I know it runs (most) Final Fantasies, Suikodens, Breath of Fires, etc. etc. blah blah blah. try buying/borrowing games and see what works!
Some RPGs known to run reluctantly in VGS albeit going through a lot of hassle include Valkyrie Profile and FFIX.