Sorry, long post, but I really have to rant and rave here. But I tried to make it funny.

Hope you enjoy.
In the vein of BG3, maybe Dragon Age: Origins? They share a lot of DNA, to the point a lot of people consider BG3 a spiritual successor to DAO. Party-based narrative fantasy RPG with some novel worldbuilding, excellent characters, and tactical combat (though you really need the PC version to fully appreciate it; console versions lack the tactical camera, which limits what you can do). It does show its age in some areas, but it’s held up well overall.
Absolutely agreed. All the characters in DAO rule. Oghren gets the best lines, but Morrigan and Alistair have a few words to share.

Also, try Oghren and Shale. "Passing a stone, get it?" / "I'm trying not to".
Dragon Age 2 is ... passable, but I'll only give it 6/10 because it's impossible to craft your own equipment with runes (unlike DAO).
Dragon Age 3 is crap. Runes are incredibly difficult to get, and without them, you can't beat Pride Demons (aka fire spirits, whatever), and forget beating any dragons.

I eventually defeated the game with unenchanted weapons, and that was the only time I beat it.
Plus, it goes on and on and
on. Plus, if you want to open that oh-so-secret door somewhere in the mountains, you have to scour the landscape and find 30 pieces of a key.

Who has time for that?
So after those two shitshows, it'll take a long
long time before I give DA4: Veilguard a chance. Which is too bad, 'cos DA3 ended on a banger of a cliffhanger, and I really want to know what happens next ... but not at the expense of having to sit through another shitshow like DA3.
I played part of the first Assassin's Creed n didn't care much for it/ Everyone else loved it. They'd say, 'go collect 20 blue butterflies,' and I'd be like whut? why? Then I would and after like 2 hours lookin around it'd be like here's your 100 gold, now go find 30 yellow ones. I was like, naa, and pretty much naa overall. Same w RDR2.
Agreed. There was the same problem with Oblivion (minorly), but especially Skyrim.
Alchemist: Go get me 10 dangerous ingredients, 10 more dangerous ingredients, and 10 especially dangerous ingredients.
Me: And what do I get for all that?
Alchemist: 500 gold.
Me: Falafel you! If I get that many poison ingredients, I'm gonna use 'em to buff up my own alchemy score. Go rooting around in swamps yourself.
.......
Every Jarl's Assistant: We have a problem!
Me: Figures.
Every Jarl's Assistant: No, really! We need a brave hero to kill these bandits, wolves, and/or giants!
Me: Let me guess, and your guards are too incompetent and lazy to do it themselves ... even though they faced down and killed a dragon.
Every Jarl's Assistant: Exactly! So you go and do it! Please?
Me: Oh, fine.
(after getting killed about 10 times by a giant ... and nearly getting killed by the bandits)
Every Jarl's Assistant: Hey, thanks! Here's 100 gold.
Me: Yeah ... which I will totally not piss away at the nearest tavern, smithy, and/or miscellaneous shop.
.......
Blacksmith: Go get me 10 pieces of iron ore.
Me: All right, and do I get anything for that?
Blacksmith: How about some training for your smithing score?
Me: Nah thanks. If I get iron ore, I'm gonna smith some iron daggers and buff up my smithing score myself.
........
Another Blacksmith: Can you give this sword to my father?
Me: OK. Do I get anything for it?
Another Blacksmith: Nah.
Me: Then I'll just use this sword to fight with. Thanks lady!!!
(Years later, coming back to Whiterun and handing the sword over to her pampered dad)
Dad: Gosh, thanks. Here's 20 gold for your trouble.
Me: (goes nuts and slaughters dad)
........
Yet Another Blacksmith: Go find me the Helmet of Someone Really Famous Wot You Never Heard Of.
Me: All right!!! Finally a quest worthy of my time!
(After slaughtering like fifty bazillion
draugr, including a really tough undead guy, and
schlepping the totally ordinary helmet and all this other loot to town...)
Yet Another Blacksmith: Gosh, thanks! Here's 100 gold.
Me: ........ and what'll you give me for all this other heavy loot?
Yet Another Blacksmith: ... 300 gold?
Me: ........ riiiiiiight. And how about this totally neat magic sword?
Yet Another Blacksmith: ... how about 400 gold?
Me: Sigh. I really need to work on my speechcraft skill.
Yet Another Blacksmith: At least you don't have to put up with that wheel thing from Oblivion, where you try to persuade merchants, and they only take one gold off the price.
Me: Fine. So how can I buff up speechcraft?
Yet Another Blacksmith: Try the Bards College.
(later, at the Bards College)
Bard: Welcome! Want to train your speechcraft?
Me: Sure!
Bard: That'll be 500 gold for one point of speechcraft.
Me: (taps foot, eye twitch) This better be worth it.
(A king's ransom later)
Bard: ... and now your speechcraft is up to 40! Cool, huh?
Me: Not really, 'cos I wanted to buy that neat-o magic sword at the blacksmith's, but I couldn't afford it.
Bard: And now you can, 'cos your speechcraft is better!
Me: Yeah, but now I'm
broke. This sucks.
Bard: Sorry! No refunds. Want more money? Go adventure some more.
(One delving into an incredibly dangerous dungeon later)
Me: What can you give me for all this loot?
Yet Another Blacksmith: Ooh, cool. How about 2,000 gold?
Me: Done! And now I want ................ what the **** happened to that magic sword I wanted?!
Yet Another Blacksmith: Sorry, I sold it to a passing hobbit. You snooze, you lose.
Me: Aaaaaaaaaaaaaaaaaaaaaaaaaaahhhhhhhhhhhhhh!! (Goes up to the highest mountain in Skyrim and "Fus ro dah"s everyone)