Here are a few things I like about those games:
Examples of games that qualify:
Examples that don’t qualify:
Games on the fence:
Basically, I want a game that forces me to learn and adapt using the limited tools the game provides. Here are things I absolutely want to avoid:
Basically, I shouldn’t have to think outside solving puzzles and fighting bosses.
Indie games are preferred.
Platforms:


A gaming community free from the hype and oversaturation of current releases, catering to gamers who wait at least 12 months after release to play a game. Whether it’s price, waiting for bugs/issues to be patched, DLC to be released, don’t meet the system requirements, or just haven’t had the time to keep up with the latest releases.
Keep playing TUNIC. It’s great.
Someone else mentioned Death’s Door which I see as TUNIC’s overlooked cousin.
Some others that are similar, have either played them or purchased and not played yet, due to similar taste to yours:
Alwa’s Awakening & Alwa’s Legacy
Anodyne
Blossom Tales series
Fountains
Lunacid
The Messenger
Moonlighter series
Unsouled
How about Death’s Door?
Seconded
Illusion of Gaia on SNES maybe?
Also Crystalis on NES.
Crystalis totally fits the requirements. Excellent NES RPG.
And by extension Terranigma and Soul Blazer.
Also Secret of Mana and Secret of Evermore as well.
Have you played the existing Legend of Zelda titles? I mean, there are a ton of them. Even if you stop at Tears of the Kingdom and Breath of the Wild:
https://en.wikipedia.org/wiki/The_Legend_of_Zelda
Lies of P seems like it fits most criteria. It’s much less “build your DnD character” than Dark Souls, you have a handful of options but the focus is more on level design and boss fights than customizability from what I’ve played of it. Like Bloodborne but with a narrower focus.
I feel like Sekiro would meet most of your criteria, except for the dungeon aspect.
Seconded
CrossCode is probably on the fence of what you’re looking for.
Lots of gear in it, though, otherwise a fantastic recommendation.
You might like Alundra. PlayStation game. Here’s a long play so you can see what it’s like: https://youtu.be/C7GXOjlshqg
How about Spindle?
Also, girl from Arkanya.
I may have some more that fit too, I’ll have to search later 👍