I'd agree that a majority of games fail at appealing to me for sheer fun and "immersion," regardless of how slick they are graphically.
I do like multiplayer online games a lot though, particularly team shooters like the Tribes series, or even the FREE America's Army.
And only today I reinstalled System Shock 2, which years after it's release still outshines most in gameplay and atmospheres/environments.