Concerning eso, i’ve heard very polarizing things. Your take is rare to me, in that it falls within the gray area. People either shit on it or worship it, in my personal experience.
the problem with eso (granted no game is perfect) depends when you played it, where you come from and how much you can stomach the combat.
if you're an elderscrolls-fag it plays a bit too fast and lose with the lore, which people still whine about 10 years later, but for me is more like "kotor isn't the original trilogy" and I can keep it separate.
eso at launch was also a bit rough and undercooked (without going into it they were going for dark age of camelot pvp endgame initially, to then scramble to have enough pve content for launch since that's what you need if you want to appeal to the mainstream), complete with trying to ape wow's progression and payment model afterwards.
after roughly a year when it was obvious that wouldn't work out ZOS (almost) completely retooled the game into a guild wars-clone which worked out much better. however you can never remove progress from players (unless you want your game to crash and burn right then and there), so the current leveling and gear-cap level are a relict from that retooling 10 years ago - the gearcap is basically the old maxlevel from back then (and hasn't changed since and probably never will), and there are still 50 levels per character etc.
that means the game you played 10 years ago is quite a different game, and even starting now having to level first makes it look like a run-of-the-mill linear progression mmo lot of people people burned out from over the years. ironically you can't just dump new players right into it with access to all the subsystems otherwise they get overwhelmed. damned if you do, damned if you don't.
combat is probably biggest point since it takes some getting used to, made somewhat worse by said leveling. not only do you need the combat to click, it takes quite a few hours (even if you speedrun it, even more if you're a casual) till you get access to enough skills and sets (gear isn't just higher numbers, but also an extension to your skills and character) to get a real feel for the class, and there are enough differences between them where one class might be a better fit, but there's a good chance you'll never get to that point. the initial experience (especially when you play it like a classic mmo) is quite different.
even for me it took a while to get off my ass to really look into it and "get it", but after that point and figuring out what the game actually expects it's great. for example every class has a skill for a buff that gives 20% more damage. some classes only unlock that later on (with one class being able to buff the whole group, that's more or less how ESO's teamplay works since you only have access to 10 skills + 2 ultimates, meaning in a group they can replace that skill that buffs themselves with something else), but it's still right there in the tooltip. now take a guess how many players conveniently overlook it or simply think it's not that important.
funny enough it still beats gw2's "lol faceroll" combat, and if you play it like that it will feel even worse - there's no global cooldown, you have to juggle resources and know when to use what to not run empty and whiff autoattacks. there are outright skills that will drain you dry since they're not supposed to be spammed (unless you properly gear for it with, and then only in a group).
as much as "it gets good after X hours" is a meme, sadly that's how it works, with no guarantee it will for you. it IS still a mmorpg after all.
however as I mentioned before (and elsewhere probably) it's also a great filter. the people you'll end up with in the challenging content are there because they want to, not because the game forces them to get purple pixels with higher numbers. content is still challenging later on (there's stuff from 2016 that still fucks group today), lot of nifty little design decisions to curb some of the usual mmo drama shit too while lowkey improving the community aspect overall, even if changes take a while to happen (if anything ZOS is pretty slow changing stuff, but that's also a pro for some people, and by now most issues have been more or less "fixed"). so even outside the sweaty circles (except pvp because that's just how it goes) most people are pretty chill. interestingly a lot of boomers (real ones and the meme ones), still no idea if one is the reason for the other or vice versa.
EDIT: I also should mention since the goal is not have you to grind for higher numbers over and over but collect a lot of sidegrades, with plenty of other stuff to do if you care about it, there's a good chance it will sour you on other games. anything that tries to hook me via linear progression can fuck right off, and since loot is deterministic - meaning you know exactly how long it's gonna take to get most of the stuff you care about, even if it takes a while, but it also means if you grind hard you'll get rewarded appropriately and not just another pull on the slot machine - all the games that try to sell me RNG as "endgame" can fuck right off as well.
I've played ESO since release and it's a decent game with fun to be found if you look for it. That being said I also find it's incredibly easy to get burnt out on. Recently I've taking my time actually roleplaying my character (RP walking, avoiding certain quests/activities, etc.) and it made the game a lot more enjoyable for me. Also avoiding PvP like the plague is a must in my opinion.
luckily with capped progression you can just take a break and come back later, without having all your gear invalidated and having to grind through the last 2+ expansion to catch up. since sub is optional you don't have to drop money first either.
pvp can be fun if you don't go full sweat and stick to zerging in cyrodiil. can't even think of a current mmo which offers siege-pvp besides gw2's knocking on doors.