Wow, that was quite a lot to plough through! While it's great that people have all these great games to recommend (I've enjoyed reading) it seems that many people aren't quite up to speed on my parameters, making my responses thankfully short
Mount & Blade - It has the first-person camera (over the shoulder).
Skyrim - Is part of the Elder Scrolls series, already discussed previously.
Risen - It has the first-person camera (over the shoulder).
The Last Remnant - Designed primarily for consoles.
All of which are more aRPG than cRPG or more console games than PC games etc.
Summoner and Summoner II - 2000 and 2002
Temple of Elemental Evil - 2003
The dates are there for a reason, also I have already owned/played ToEE. You wouldn't have known that I'd already played it because I didn't list it, but I didn't list it because I didn't expect anyone to list games that fall outside the brackets the thread imposes
City of Heroes - It's an MMO...
Nothing on-line only please.
Knights of the Chalice - 1990 graphics in a new game.
Avadon 2 - 2013/14 and also 1990 graphics in a new game.
Possibly maybe. While possibly being great games, awesome even, I'm not sure to what extent they 'feel' like 2005-2012 games. Weird one this. I'd be more inclined to try Knights of the Chalice out of the two if I did fancy trying the uber-retro angle.
NWN II Expansions and Mods - Awesome suggestion.
Certainly all good recommendations to short-list
Drakensang: River of Time - Looks about right.
Of all the suggestions, this one definitely seems to tick every single one of my boxes, I can't find any reason whatsoever as to why I would dislike this game.
I think we have a winner
Unless someone has any other ideas?