I agree that ss2 was better, but compared to the games coming out in the last ~8 years, BioShock is way above average. So is Mass Effect. They didn't suck me in completely and take over my imagination whole they way some games in the 90's did, but they definitely moved me, perhaps because I wasn't trying to compare them to anything as I was playing them.
Oblivion is below shit regardless of the scale though. Fucking Bethesda.