WoW classic
Fallout 3
Diablo 3
TW Warhammer
Eve Online

Have you tried the original Deus Ex? It's a first person RPG in the Quake 2 engine, widely considered one of the greatest games ever made. The same studio also produced Anachronox - an American produced satire on JRPGs, also fantastic, but the ending sets up a sequel that was never made.

I'm pretty sure most results would be classic Nintendo titles and not computer games.

You may have already played them but the Civilization series is a great turn-based 4X strategy game series and Civ 3 is considered among the best in that entire genre. Also, Sid Meier's Alpha Centauri, which is essentially Civ in a sci-fi setting. I'd also say that in terms of RPGs, the Ultima and Might & Magic franchises are must-plays. Also, the spinoff series from Might & Magic, Heroes of Might & Magic, is a great turn-based strategy-RPG hybrid that has several games within it that people consider to be among the greatest strategy games ever.

IMO, the best reviews in the 90s =
Scans of the PC Gamer UK top 100s:

https://www.pixsoriginadventures.co.uk/top-100-pc-games-in-1996-pc-gamer/
https://www.pixsoriginadventures.co.uk/pc-gamer-top-100-1997/
http://www.pixsoriginadventures.co.uk/pc-gamer-top-100-1998/
https://www.pixsoriginadventures.co.uk/pc-gamer-top-100-1999/
http://www.pixsoriginadventures.co.uk/pc-gamer-top-100-2000/

I find that this a better starting point (+follow up research by yourself) than the recommendations from strangers on a forum (yes, I see that there's some irony here).

90s?:O
why would anybody want to play those ancient games?
isnt retro and classic refer to 15-20 year old games?

^ https://www.youtube.com/watch?v=sTSA_sWGM44

I could post this every time, but I have a life.

This is a bit of a broad request. I could hit ya up with titles all the way from Akalabeth to Avernum: Escape from the Pit.

oh thats why you keep pressing the - :P what a wonderful life it is
btw for us born around 2000 retro/classic is 15-20 years old games , not 30+

All the ones you mentioned are games I've played and consider them to be some of my favorites.

Since you mentioned that you don't mind more modern titles. Have you tried any of these games?
- Titan Quest Anniversary Edition - (Action RPG, reminds me of Diablo 2)
- Grim Dawn - (Action RPG)
- Divinity: Original Sin - Enhanced Edition - (Turn-based RPG) (I'm currently playing this one)
- Torchlight II - (Action RPG)

All these games as far as I know have multiple modes for casual players to those that want a higher challenge, except maybe Torchlight 2, which is pretty easy going anyway.

Some older games that I consider fun classics (all are basically RPGS):
- Darkstone
- Evil Islands - (from same people that released Rage of Mages)
- The Temple of Elemental Evil - (Temple Plus mod is a must for me though)

There are plenty of other good ones and I see people listed some already. And believe me, I was in a slump not too long ago myself. I get that way when it comes to reading my eBooks too. I think maybe I overdo it, instead of taking a nice long break in-between every now and then lol.
.

Solasta is a good one , now it has new classes too.

I remember these! Especially the 1996 one. Ahh the memories - back when PC Gamer was good, rather than the dumpster fire it is today.

Baldur's Gate (PC, 1998) & Tales of the Sword Coast (PC, 1999)(Expansion)
Fallout 2 (PC, 1998)
Heroes of Might and Magic III (PC)
The Typing of the Dead (ARC, 1999/DC/PC, 2000)
SimCity 2000 (PC)
Unreal Tournament (PC, 1999)
Starsiege: Tribes (PC)
Baldur's Gate II: Shadows of Amn (PC) & Baldur's Gate II: Throne of Bhaal (PC)
Quake II (PC)
Dragon's Curse Remake (fan remake of WB3)(PC, 2008)

X-COM: UFO Defense/UFO: Enemy Unknown (PC)
System Shock 2 (PC)
Tom Clancy's Rainbow Six: Rogue Spear (PC)
Cannon Fodder (AMI/PC, 1993/MD/SNES, 1994)
Deus Ex (PC)
Strife: Veteran Edition (PC)
System Shock: Enhanced Edition (PC)
One Must Fall 2097 (PC)
Gravity Force (AMI)
Oddworld: Abe's Oddysee (PC)

I have to say you're missing out on some great ones by avoiding RTS games. I'm not a big fan of P&C adventures either but there are good games there as well.

If you are into RPGs in general, download The CRPG Book. The PDF is free (thanks to its editor, Felipe Pepe), although there is a physical book for sale by Bitmap Books.
It shows and tells about all the main CRPGs from the 70s all the way to 2015. Great reading.