Preferably in the high fantasy or sci fi genre.
I enjoy playing games like Chronotrigger, Tales of Symphonia, Witcher 3 (easiest difficulty), Mass Effect (in Story mode), Outer Worlds (in Story mode), etc.
Basically, story first, mechanics second. What’s your fav?
As people already said, Disco Elysium for sure.
Baldur’s Gate 3 on the lowest/story difficulty.
The old RPG Arcanum. Great steampunk fantasy setting and story. If you play a persuasive character you can avoid combat and skip entire dungeons. The game has some balance issues (magic tree is fine, but the tech tree is underpowered, and early combat encounters are horrible to dela with). Various fan patches and mods are available, including a balance mod, a bugfix patch, and an HD patch. Since it’s an old game I recommend getting it from gog.com, since sometimes they fix up older games a bit to run properly on new systems.
Dragon Age, since you liked Mass Effect. Though, I personally found the combat more annoying in Dragon Age than Mass Effect. Mileage may vary.
The Outer Wilds (different game than Outer Worlds). It’s a sort of an archeology/space adventure game. It’s not strictly speaking an RPG, but if you want a story game it’s top tier. Please do not look anything up about the game and go in as blind as possible, as the feeling of discovery and exploration are the main draw of the game and once you have something spoiled you can’t un-know it. Also, I recommend getting the dlc immediately with the main game, as it’s a huge expansion that fits into the main story perfectly and affects the ending of the main game.