>>16961262 (OP)
Fallout 1, 2 and Tactics
System Shock 2 (first part had outdated graphics and somewhat dated gameplay but good as well)
Anachronox
The Nomad Soul
ZanZarah: The Hidden Portal
Darkened Skye (literally game about Skittles)
Heavy Metal: F.A.K.K. 2
Dark Messiah of Might and Magic
Thief (all of them)
NWN with popular modules from https://neverwintervault.org/article/reference/neverwinter-nights-hall-fame (highly recommended)
Paradise Cracked (and the next part Cops 2170)
Fantasy wars (crossbreed with TBS) with all additional campaigns (Elven legacy especially recommended)
Ascension to the throne (also the second part named Valkyrie)
Soldiers of anarchy (this one more like RTS)
Space rangers 1 and 2 (turn based space RPG)
Star wolves (real time space tactical RPG)
Parkan 2
A.I.M.: Artificial Intelligence Machine
Drakensang (and River of Time)
I would also recommend Nexus: The Jupiter Incident and Haegemonia (both are space RTS actually but with heroes and freaking epic story)
Wizardry (haven't played myself but heard it was good)
Warning: Russian and Ukrainian games somewhat poorly translated. Also many games in this list not a straight RPG.