Clair Obscur: Expedition 33 is probably one of the best games I played, it has RPG elements and the turn-based combat system is unique and satisfying. But this is not a game that will bring you joy, the atmosphere is bleak and it is a dark story.

In fact it kind of ruined RPGs for the moment at least, I played Metaphor:ReFantazio right after and the stakes just did not feel serious enough even 10 hours in.

Games that I really enjoyed:

• Final Fantasy 7 through 10
• Final Fantasy 5

So... did you skip FF VI or did you specifically not like it?

For a Stardew Valley type RPG, check out Little-Known Galaxy. I haven't gotten far in its story but it's been pretty fun.

For more traditional RPGs, I enjoyed Cross Code, though it is a bit grindy if you want to 100%.

Sea of Stars also has a great story.

For games with voice acting check out Kingdom Come Deliverance and its sequel.

The Forgotten City. More of an adventure game but has good story.

one of my all-time favs is an ancient one.. phantasy star II. you'll need the sega thing on steam to run it...

the story is good, graphics are very stardew valley.

the only negative aspect from your list is some minor grinding and the randomness of bumping into creatures.

Xenoblade Chronicles 3 was amazing and made me want to play the first two but that damn Nintendo tax has prevented me from finding it at a decent price on the secondhand market.

Since you mentioned FF series, don't sleep on FF12. It is up there on my top games as it was the first one I played where I could automate my group.

How do you feel about Skyrim? I kinda want to recommend Morrowind via OpenMW, which should run fine on the Deck, but I guess both games would feel too much like DnD for you.

Undertale, if you haven't played, might be fun.

You can also check out Trials of Mana, which is a remake of the SNES game and, unlike the remake of Secret of Mana, doesn't seem to have any unpatched game breaking bugs. Other JRPGs that might be work checking out are the "Ys" and "Legend of Heroes" series, both should have plenty of games that play fine on the deck.

Lastly, Rune Factory, which is fantasy harvest moon (the farming sim that started it all, so to speak) with some light dungeon delving and leveling up.

Don't know if by dnd mechanics you mean any games inspired by tabletop rpgs or not and most of the gamesin your list being jrpgs. Age of Decadence is one of my favorite with interesting setting, Serpent in the Staglands is another one. Not exactly a rpg but interesting ~~no truce with the furries~~ Disco Elysium.

I think you might enjoy the Atelier series. There are a lot of games in the series (~26 entries); Barrel Wisdom gives a good breakdown, but, generally, Atelier Ryza is a good starting point