The fact you have to start your comment with multiple don’t do X things proves my point. As a story it’s great, but as a game it’s got a lot of problems.
The level up system was bad. The thrust/chop/slash system for weapons is awkward. Every attack costing stamina is bad for early characters. The excessive number of weapon categories, combined with short and long blades being the only ones that were common. The persuasion system was just bribe people to get what you want, or taunt them for free murder. Run speed being a skill, jumping being faster than running and being a skill as well (combined with the level system this can cause problems). Item durability in general. The encumbrance system, and containers having weight limits. The spell making and enchantment system had some cool things, but it was also trivial to break the game in multiple ways. The quest tracking and journaling was garbage. Alchemy was undercooked. Merchants had way too little gold so selling became annoying by mid level. The haggling quickly got annoying as you could sell at extreme markup or buy for nothing fairly easy. Magicka didn’t regenerate, so being a mage was annoying at early levels until you had sufficient potion access.
There’s also some things that are more bugs I think than bad mechanics. Stealing from a merchant flagged every copy of an item as stolen from them. I once managed to make every redoran guard hostile to me on sight, which got really annoying.
There’s never been much content blocking in elder scrolls. You could always master every skill even in Morrowind. Morrowind had a few exclusive guilds, but even Skyrim had a couple. Role playing in Skyrim is self imposed.
There two big differences to me are scale and value. A ccg has rare cards, but they aren’t actually that rare compared to loot boxes. Loot boxes tend to have both lower drop rates and pollute their drops with lots of garbage, even for rare drops. Secondly, physical cards have value, you can sell or trade them, you can buy singles of cards you want. You can use them for things other than the game as well.
As others have said start with 5. The rule of thumb for civ games is to wait for the expansion dlc to release and buy the game on sale. 7 is also a significant departure from the previous games, so it’s probably even more important to wait or outright skip it until they get it more polished.
Also it’s worth looking into endless legend or endless space 2 if you want to try more 4x games.
I haven’t actually played any of the old monster hunters before world, but from what I understand they are far more clunky, and you tend to fight the game almost as much as the monsters.
I’ve tried a few space RTS games, and it’s not my favorite. They tend to be extremely slow paced to simulate the vastness of space. At super low prices it can be worth it to try out, but it’s definitely a different experience to consuming a map with an ork waaaagh.