Okay, before I get into this, let's lay some ground rules. First, Final Fantasy VII is the greatest game ever made, and it is only even rivaled by The Legend of Zelda: Ocarina of Time. Those two are far and away the best things to ever happen to the world of videogames. No arguments. (Unless you really want to. ) Second, RPGs are inherently better than the vast majority of today's shooters. I am biased towards the RPGs, but I'll give you a reason.
For some unfathomable reason, Halo became so popular that everybody wanted a piece of the pie. So 8 quadrillion (dangerously exaggerated hyperbole here) shooters were made over the next 8-9 years. Almost all of them are carbon copies of the one that came before them. That's one of the reasons I don't like them as a whole. Plus, I just don't think they're fun.
There are a couple shooters I can stand, but they are all rated M. So no talkie. The game I am playing currently is Baldur's Gate II. It is definitely the best game ever made that wasn't created in Japan. (Darn it, I'm dealing in absolutes again! Only Sith deal in absolutes! Bad Romulus!) But anyhoo, I love it to death. I'd recommend it to anyone with a computer. Seriously, it's from 2001. If you own a computer, it can probably run BGII. No promises though. I know there are some old PCs out there still.
Some other games that I love would be: the entire Final Fantasy series, with the exception of FFXI; The Legend of Zelda series; Jak and Daxter, but especially the first and third ones; Ratchet & Clank, these games are absolutely hysterical, but are some of the most finely crafted action-platformers ever made to boot; everything made by BioWare is pretty much fantastic, but especially the afore-mentioned BGII, Neverwinter Nights, Star Wars: Knights of the Old Republic, and a couple games that are rated M (if you play RPGs at all, you should know which games I'm talking about); The Elder Scrolls III: Morrowind is incredible; Dungeon Siege honestly isn't super great, but it was my first RPG, so I will love it to the grave; and, last but not least, Spyro the Dragon. Spyro was the very first game I ever owned, and the second I played, and for that, it shall always hold a very special place in my heart.