Buying a PC game...

Hi, I've been thinking about getting a good PC game for christmas and was hoping I could get some ideas. I'm looking for a game that checks everything below:

@Great graphics and great high quality textures...
@Playable without needing to be constantly connected to the internet (validation crap)
@Something reasonably open world...
@Has great freedom for modding and making mods

>inb4 Skyrim

Skyrim

No constant online connection? Good luck. Not being a dick, but that will never happen if it's a game that's younger than 4 years old.

Onto your question. Oblivion, or Fallout 3. Funny thing about what I just said, these two in particular don't recquire any intrawebs to play. Fallout New vegas, however does.

That's all I can really think of. That don't recquire validation garbage anyway.

Luck.

Age of Empires I II or III
Age of Mythology
Skyrim
Dawn of War: Dark crusade (soulstorm needs interwebs)
Call of Duty World at War (or older)
Fallout III
Diablo II
Warcraft III
Battletoads
get a N64 emulator and torrent a copy of any Zelda game for it