TLDR: I haven't quite finished the main story but I'd give Hogwart's Legacy something like a 7/10. For me, the first half of the experience, more or less, is the better half. Don't take that too negatively - for me a 7 is still a quite positive rating, the game simply could have used a little more complexity here and there to keep it from becoming too repetitive or "pointless" (outside of following the Story I mean).
EDIT: one system would be consequences for some actions/dialogues to add a little weight - because there aren't any. Or at least almost none. I'm not huge on needing mega consequences in RPG's but at least a little bit would've been nice. I at first used stealth while lockpicking for example, until I realize there was no need. No one cared, outside of one or two specific quest times. >.>
===========
I think I am nearing the end of Hogwart's main story and am sorta rushing to get that finished now. Haven't explored the lower half of the world very much. It must be said that this is partly because with my thoroughness, I'm already level 36, have the Collections at 90%-100% finished (which does not mean you've done, collected or seen "everything in the game", mind) and my combat abilities seem to be such that most fights last 15-20 seconds. So...there isn't a ton of motivation left for me. One could leave a lot of that for after Story, instead, but that's not my way. 😄
It's still beautiful and exploration is still fun in short doses, but like many open worlds there just isn't quite enough "to do" - or more specifically, there's things to do but it becomes very repetitive, and the loot-hunt aspect is not very engaging or imperative past a certain point. So it's just whether you have personal, small goals of your own or just love scouting the castle/landscape etc.
Some of the longer side quests have been more fun, although I wish the temp-companions during those quests had more heft. Only one of them has any significance in that regard, imo.
the game economy felt pretty nicely balanced at the start, in terms of being a little bit of a struggle to do what you want, but after you've bought what you can buy, there is almost no use for money that I have found, and it just stacks up uselessly. I've stopped picking it up even.
That all said, I definitely got my monies worth, had a pretty good time, and while it's simple, it's a well made game world and a great effort. With the success, I hear WB recently announced more games and maybe a tv series. Hm. Well, we shall see.