The camera mode can actually be switched on the fly between the pseudo-isometric overhead views (low- and high-angle) and the over-the-shoulder "follow cam" view (which is what I mostly played in).

Septerra Core was the first game I played. It holds a special place for me. But, that apart, I found the story and lore interesting, also how the magic system works. I enjoyed playing a female protagonist and the relationships between the characters can hold some depth - if you choose to engage with the game in that manner.

I loved the difficulty spike in NotR. Plus, there are additional quests and narrative depth that come with this version of Gothic II. The difficulty does mean you have to pick your fights very carefully at the start, but this scenario does improve quite rapidly.

One game I missed off was Divine Divinity - loved the humour and the Easter Eggs, also the skill tree in this one.

Arcanum, obviously, it's made by the same people.

Scartch try PLANESCAPE TORMENT I'm sure you will love it and it's music sounds LOVELY

What about DARK? Not on GOG(yet) but seems decent in the vampire rpg genre.

http://store.steampowered.com/app/225360/

I'll second ShadowRun

https://www.gog.com/game/shadowrun_returns
https://www.gog.com/game/shadowrun_dragonfall_directors_cut
https://www.gog.com/game/shadowrun_hong_kong_extended_edition

I've played and completed the first two and they've very well done, great story telling and atmosphere.

I didn't know that, but then I prefer iso view so I never actually looked to see if the game had another angle.

I like to have as much info available as possible. The Witcher's combat system might have been my absolute favorite in an action RPG. I know a lot of people hate it, but I really enjoyed the parrying, heavy, quick strike system with blocking and taking on multiple enemies at a time. I just find it so much better from iso view as opposed to getting hit in the back or from the side by an opponent you can't see.

I think exploration and NPC interaction is better in over-the-shoulder mode, while fighting against groups of more than about two enemies is slightly better in iso, if for no other reason than the improved situational awareness. (Combat with one or even two enemies is fine in OTS, I found.)
Of course, I always forgot to change the camera mode when I found myself in combat, so I wound up doing almost every battle, no matter the size, in OTS view anyway. :P

May I suggest some of my favourites games of likewise nature?
Never actually played Vampire but judging from the looks of it, games like KOTOR, KOTOR II, Shadowrun, Fable (I enjoy the second most but it's consol only, otherwise get the first one), Dragon Age and Witcher 1 (it runs great on most machines) should suit you. I started playing Witcher 1 just last week and I'm really enjoying it so far.

KOTOR has a relatively high replay value, I myself have played the first one four times and the second three times.

Wow! Can't get over the great response.
I'll have to go carefully through the suggestions and research each.
Today, I have to get back to "the real world" and do some needed chores.
Thanks so much for all your help.
Scartch...