I found (too) many good RPGs (and you can find something for yourself)

Arc Rise Fantasia on the Wii. Be careful, the game starts out with a lot of exposition and some questionable voice acting, but everything after the first few hours is great. It's fairly difficult though.

You're probably better off searching your Steam livrary for RPGs you already own and haven't played. There's a lot of good stuff fin there.

Dragon's Dogma Dark Arisen
The original.
Still runs well on new PCs. Tons of lore, combat, skills, mixable vocations (skill trees) and the Pawn system.
Love it, my current addiction.

Have you played Anachronox yet?

Cyberpunk 2077 with Phantom Liberty

ys VIII, best game of great series

Pillars of eternity games I don't think has been mentioned so far. Also a special mention to any of the Fallout games especially with the tv series out at the moment as they are great.

World of Warcraft as a MMORPG is another option to try.

You may have already played these but here are some that I have enjoyed.

• King's Bounty: Crossworlds (Haven't played KB2)
• Deus Ex 1, Mankind Divided and Human Revolution
• The Witcher series
• Diablo series
• Fallout series
• Baldur's Gate 1 & 2 (haven't played 3)
• Divinity 2
• Divinity: Original Sin 2
• Star Wars: KOTOR 1 & 2
• Tyranny
• Pillars of Eternity 1 & 2
• Wasteland 2 & 3
  Edit: How could I forget Jade Empire!

Chained Echoes
I was a naysayer who struggled to play more than 2 minutes to get started at this pixelated ok looking game.......Eventually got to it, and was glued to it for HOURS!

As always when this question comes up I recommend Enderal https://store.steampowered.com/app/976620/Enderal_Forgotten_Stories_Special_Edition/

If you fine with older games, give a try to Divine Divinity, it's a hidden gem, althouth a rough one:)

fallout 2 ?
silent storm ?

A lot has already been mentioned here. Maybe the Pathfinder series could be worth a try, though I only played Pathfinder: Kingmaker and didn't get very far yet. Also if you're okay with diablo style games, The Incredible Adventures of Van Helsing was nice, but I don't remember much of the story.

Have you tried the classics, Baldur's Gate 1 and 2, Icewind Dale 1 and 2?

the outer worlds

My completely-ignoring-your-examples-and-preference-for-medieval-setting recommendation is CrossCode, because it's a great game!

Let's see... only fantasy setting RPG I can think off which hasn't already been mentioned is Kingdoms of Amalur: Re-Reckoning. (Which I just finished playing a few days ago, convenient! XD ) It's kinda like Skyrim but if it was less buggy (I mean... that's not saying much... and it has a fair few bugs, but nothing too egregious; I guess jank kinda comes with the territory of being a huge RPG) and had much better combat (You know how mage weapons kinda usually suck and just exist to buff spells? Well, in this game they are badass on their own.). It has a similar thing where it's a huge world with a big overarching quests but you end up sidetracked with all the small stories in the sidequests. And, since I'm an insane completionist I can say exactly how many quests there are based on my final quest log- 299.

If it has to be turn-based, then how about Fairy Fencer F Advent Dark Force. It's pretty good. And very funny. By the same developers as the Hyperdimension Neptunia games (speaking of which, if you're feeling in the mood for goofy comedy with a truly ridiculous setting- being kind of an anthropomorphism of the games industry, then Hyperdimension Neptunia Re;Birth1, Re;Birth3 and Megadimension Neptunia VII are all very good and very funny; with 3 being the best in my opinion, and Re;Birth2 not worth mentioning because it sucks in my opinion, lol). Actually, most Idea Factory + Compile Heart RPGs are pretty good, if you don't mind them being JRPGs. And don't mind them reusing the same map and enemy assets in all of them. ^_^'

Hmm, what else... let's see- people already mentioned Zwei, The Legend of Heroes and Yakuza... Borderlands is just completely different from what it sounds like you're looking for... Ah, there's one that no-one will ever mention:
Edge Of Eternity- this one is kinda... rough around the edges (no pun intended) since it's made by an indie studio which probably aimed a bit too high, but it is a pretty interesting game. Story-wise it's about a fantasy setting which is at war against what are clearly super advanced futuristic machines while at the same time being ravaged by a mysterious affliction which mutates people into horrifying monsters. Combat is pretty interesting too, using a hex-based grid and putting a lot of emphasis on positioning. I'd say the main problem with it is... that the story feels unfinished... (It follows a specific goal for about 2/3 of the game and then is suddenly hijacked by a different threat and after that threat is dealt with in a big dramatic manner, the game just kinda... ends, with the initial goal unresolved. There are some assets in the game which imply that it was supposed to go all the way to a real ending, but the devs couldn't pull off the whole thing in a single game... So, yeah, fingers crossed that they add the rest of the story later or they make a Legend of Heroes-style Part 2 or something, but since it's an indie studio, that's... very uncertain.)

Anyhow, here's another great game- Epic Battle Fantasy 4 (probably 5 too, but I don't have that one to say anything concrete about it). It's another funny comedy game with lots of jokes and humor but it also has one of the most in-depth combat systems I've seen in a turn-based RPG. This is a game where resistances and weaknesses, status effect, buffs and debuffs, etc actually matter a lot!

AKIBA'S TRIP: Undead ＆ Undressed - You liked Yakuza? Well, here's Yakuza but somehow even weirder. Imagine it kinda like a mini-Yakuza game without the... y'know- yakuza. It has similar exploring a small neighborhood in Tokyo with side quests and minigames and stuff... but in this one the bad guys are "vampires" who, unlike the usual kind, are just fine in the sunlight... as long as they're wearing clothes. So the combat is about undressing them/destroying their clothes until they're left in their undies and burn up in the sun (or when fighting regular humans- until they are too embarrassed to keep fighting you, lol). So, yeah, it's another game in full goofiness territory. It's kinda like a dress-up simulator too since you can basically have your character wear all the clothes. XD

Indivisible is kind of a mix of RPG and Platformer Metroidvania with sort-of-turn-based but also heavily skill-based combat.

South Park: The Stick of Truth - if you find South Park's style of humor funny, then you'll definitely also find this game funny. XD (Oh, and also it has a whole game in it too.)

Chantelise - A Tale of Two Sisters - Best fishing minigame! Oh, and the rest of the game is very good too! Also has a nice sense of humor. (It's kind of like a predecessor to Recettear: An Item Shop's Tale but that one is equal parts a shop management simulator as it is an RPG, so I'm not sure if it'd be to your liking. If that doesn't sound like deal breaker though, it's one of the most charming games I've ever played. Chantelise doesn't fall too far behind though.)

99 Spirits - Hello, unique mechanics. It's a story heavily based on Japanese mythology, particularly "tsukumogami", aka possessed objects. The unique twist is that in order to harm those spirits you have to identify the object they are possessing, which is initially shrouded in mystery, via examining it and piecing together the clues. So it's also part puzzle game.

The Bard's Tale - hilarious sarcastic parody of the usual fantasy RPGs. Here's its trailer. XD

Ok, I think I should stop now. Turns out I've played a lot more RPGs than I thought... Then again, it is a very vaguely defined genre. ^_^'

If you're fond of medieval settings maybe you haven’t yet seen Masquerada: Songs and Shadows.
It's a turn-based tactical isometric RPG with charming animated graphics. The world of game looks like a magical Venetian Renaissance with deep lore and well-written story and characters.

I looked through the comments and no one seemed to suggest it: The Age of Decadence
Maybe you'll like it
upd: Oh, you've already played it, I'm sorry, I just saw it

TES V:Skyrim,Cyberpunk 2077 and Fallout Franchise.

If you are willing to try non conventional rpgs, i thing Gnosia is a good, one, it's gameplay is the mafia/werewolf game but you level up, upgrade your stats and learn skills as you go on

When in doubt, I turn to the classics, Gothic 1 and 2.
When I have some time free, Witcher 3 never disappointed.

As for the future, the only one I would look for is Kingdom Come: Deliverance II... cautiously optimistic because the first one was great (with its huge performance problems in towns and all)

You have an awesome one you haven't played yet, NieR: Automata. This is one of the best games I've played. I posted a review for it here if your interested in reading it.

Chrono Trigger is one of the best of all time. You put a couple hours into so far. Are you not feeling it?

Summoner is an old school one that I really enjoyed, you don't own it yet. I got it on console when it first came out many years ago. It's on sale for $1.24 right now on Steam.

Square Enix has a ridiculous amount of great RPGs on Steam.
https://store.steampowered.com/publisher/squareenix

Kingdom Come deliverance

Poll missing JRPG option!!!

Might be childhood nostalgia but I really liked Dungeon siege.
2 was okeish 3 was horrible from what I remember something with the camera or skill targeting dont remember but it was infuriating that is what I clearly remember :)
Played it multiple times with friends

Played Titan quest also multiple times

Caves of Lore is a nice little CRPG made by a solo indie dev who is pretty active in his Discord and always looking to improve his game. Currently, it doesn't have all the story parts, but it feels solid atm.

There are also a ton more I could recommend that are lesser known, if you would like :)