You're alluding primarily to AAA games that target consoles. Nothing wrong with these games, but they are
generally built to target the widest possible demographic and so you're going to get some typical patterns: action + simplicity + low difficulty + crazy good production values. Probably not what you're looking for.
To find what you're interested in just step off the beaten path a bit -- right now is probably the single best time in history for things like RPGs. For instance there is literally a brand new Bard's Tale out, in the same spirit as the originals, including having Michael Cranford on board. [1] You could start your search there - the "More like this" suggestions (on Steam) tend to be really quite good. Another place to start the search might be with the remastered Bard's Tale Trilogy [2]. Definitely don't avoid games just because you've never heard of them. For instance I'd never heard of Spiderweb software but have gotten an immense amount of enjoyment out of their games. [3] If you're okay with just dropping the story and playing a turn based RPG type game purely for an incredibly phenomenal monster training/creation type system in an incredibly expansive world then the Siralim [4] series is another great thing to check out.
No affiliation with any of the companies/products mentioned here. But I was literally in the exact same situation as you. Was really disappointed that it felt like my console had every type of genre - first person shooter/stabbers and third person shooter/stabbers! I was never much of a PC gamer. Then I took the path I'm recommending here and was just left jaw dropped to realize we're seriously in the golden age of games right now, most certainly including classic RPG style games!
[1] - https://store.steampowered.com/app/566090/The_Bards_Tale_IV_...
[2] - https://store.steampowered.com/app/843260/The_Bards_Tale_Tri...
[3] - can't link
[4] - https://store.steampowered.com/app/841770/Siralim_3/