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

You wrote Final Fantasy VI wrong, twice.

I've played them all but Tales of Berseria (and I will)

But I think no one before talked about KOTOR , and both games are awesome. I really hope the remaster will be released one day!

I played FFVIII for probably 400 hours cross all versions and platforms and completed it several times including extra bosses. It is the best RPG ever for me, undoubtedly.

If you come from the pen&paper world, let me suggest you one:

Solasta

It's actually very close to the atmosphere of a pen&paper role-playing game.

It's short, it has interesting combat mechanisms (like verticality) and it's fun.

Edit: there is also this:
Knights of pen&paper A very fun game that may bring you back memories from your game sessions (it clearly did for me)

It's a complicated question cause both genres are very different. I personnally really liked Grandia 2 but this is probably because i discovered it at a time where games were scarse. It was remastered in 2015 (so technically it fits your criteria) and story wise, it's very pleasing.
I'd add that in most JRPGs, you cannot avoid random encounters. Here you can, and this is a huge QOL improvement for CRPG lovers.

There are probably more recent JRPGS that are better fitted, but will let others advise you on that, as this is not really my range of expertise :)

A challenging combo. I think Persona 4 Golden would be a suitable candidate. It is turn-based, looks good enough, great story and it's a bargain. It could be too weird for you though.

As you didn't get further recommendations let me add some alternatives:
Yakuza: Like a Dragon - it's great and you can get it from this month's Choice. So it's a pretty obvious candidate.

And two Western Indies cherishing the glory of traditional JRPGs.
Chained Echoes
Sea of Stars
They could be perfect to get into the genre.

Could try Tactics Ogre: Reborn if you like tactical battles. Story is relatively grounded, has choices that matter, and there's a decent amount of customization. The main thing it lacks compared to typical RPGs is free roaming - instead you choose where to go on a world map and the meat of the game is battles and cutscene scenarios.

I played Dark eye games , and I like them (on pc, or the pen&paper game). I even played Drakensang on physical support . I don't remember if I had the expansion at this time, But I have good memories of Drakensang itself.

What I like in a game is the story, and very often in tactical games, I find the story a bit underwhelming (not always the case though, and I know there are awesome tactical)

I indeed think Blackguards bored me (but that was 10 years ago, so I don't remember quite well) . But i will at least play Blackguards 2 one day, as it's in my (evergrowing) backlog!

Rest in peace Swordoffury, he's going to have a rough time reading through all of this 😭

Boy that was a long list! And I still have another one to process .

I'd say that indeed we may have the same kind of age, because I played or wanted many games you have listed!
I found some things that I did not play and look interesting.

So I whishlisted the following:
Ascend_Reborn
Asunder
Blades of Time
Castlevania: Lords of Shadow 2
Dragonpath
FloraMancer Seeds and Spells
Realms of Arkania Blade of Destiny
The Specter Chronicles
Ziggurat

So thank you very much for your work, it has not been in vain ! :D

I would also like to comment on these 2 games
Brutal Legend : epic story. One game that I still play from time to time. I love nearly everything in it.
Venetica Gold_Edition (an old gem if you ask me!) And indeed, an old gem that I discovered only 10 years ago and that I had a real pleasure to play!

I bit off more than I could chew :D