What with being on the console more than the PC, I can honestly say that I don't need the console (in the game, that is).
From the games listed it looks like you're in to SPRPGs, big open worlds but you're the only player; everyone else is an NPC.
For big open worlds in a single player environment, perhaps look at Far Cry 3? That's supposed to be quite epic.
The GTA series as well would be worth looking in to as well, same genre if slightly different gameplay.
Amnesia: The Dark Descent is better than the Penumbra series in my opinion, but I don't know if either would be your thing from what you've described.
I'm not sure if you're being too restrictive in what you're looking for in a game, or too vague. Some more information about what exactly it is you like about those games that you dislike about BO2 and Borderlands would be helpful.
I think you hit the nail on the head with the "open world". I also like the fact the I can use 3rd person and 1st person views and toggle back and forth whenever I want. I also like being able to use game mods when I want. I quit using them awhile back. But I still want that option. I also want the option of easily using a cheat console whenever I want. I also do not like multi-player online games. Single-player only that are installed on my PC. Using Steam is fine.
Batman Arkham Asylum
Batman Arkham City
The Walking Dead (all episodes)
Might give a couple of those a shot. Thank you.
Try something totally different like Civ 5 or C&C (but not generals, that's terrible)
I have Civ 5. But I really didn't like it. C&C tried it and gave it to my nephew.