Enjoyable but flawed. This game fell short of being something incredible.
I don't believe I'm one of many with this perception of Hogwarts Legacy but it may prove interesting to some nonetheless.
Long review below:

The Good:
+ It's a nice visual game, some parts of it look "magical" indeed.
+ The gameplay works and functions well from start to finish.
+ The story has a few interesting moments but nothing that will blow you away. There won't be anything you won't see coming.
+ The spells feel great, combat was one of my favourites aspects of the game. The devs did their job right on this front.
+ A magical adventure for Harry Potter fans, it IS the best of all Harry Potter games, really immersive in some parts, fun in others and an overall good game. All in all, your money won't be wasted here. There's plenty of content to go around for everyone.
+ Soundtrack and sound in general is authentic to what the Wizarding world should be.

The Bad:
It's a shame that many RPGs that are open world learned nothing from Skyrim, Witcher and Red Dead Redemption.

- Everything is so scripted to the point of comedy. As a result of that, it won't take more than several hours to realise how bland and empty Hogwarts is.
The best way to describe this is by comparing it to the tv series: Westworld (for those who have seen it). You feel like you're really trying to role play in a fake world.
The same animations will play in the castle over and over, the same NPCs with the same lines.
You get to experience all yearly seasons but besides some changes in the castle and around it, the NPCs react to nothing. Their garbs won't change according to the weather.

- Immersion breaking.
When you go outside of the castle in summer, you'll spot two students playing a game. That's a very nice moment to see the NPCs have activities around the castle. However, you'll reach winter and the same students are playing the same game, in their same outfits outside in the courtyard even at night time at 0 degrees C temperature. The same orchestra music that you first hear when you go across the hall will be playing throughout all seasons, through all day/night cycles. It goes from a wondrous, special moment to a tedious, run faster so it'll bother you less.
For an RPG, one of its priorities should be to establish or at least try to make something remotely natural for the NPCs to do. There's many more such situations but I won't go further into that.

- Progression is tied to the main story. You cannot interact with your dorm colleagues or anyone around the castle unless it's a quest or a silly side quest. The house you pick doesn't matter. You'll only get 1 quest per house and it'll vary the looks of your outfit. I chose Ravenclaw but was shown around by a Weasly. I was expecting to have someone from my own dorm to be my friend/guide to lead me through the castle.

- Your choices in the game have no consequence. Cast avada kadavra wherever you want because nobody cares. It's hilarious at times.

- I understand that the developers are trying so hard to be "progressive" but in their pursuit of fulfilling an agenda they made the setting of 1800s Scotland feel like 2023 woke Hollywood. You'll hear the name of "Sirona" and how special she is more times than you'll enter her tavern.

- Enemies around the world:
You'd expect the "Forbidden forest" and "any other place in the world" to be somewhat different from each other since it's an RPG.
The enemies around the castle would be of a lower level while the forbidden forest would have tougher or more dangerous enemies. That's not the case.
You'll fight: humans, spiders, frogs, wolves, trolls, goblins and That's it. There won't be a special enemy type anywhere in this world.

- No interesting side quests or random events. Hogwarts Legacy doesn't have a natural side quest in it. You're exploring and suddenly you come across something - well, kinda... Some merchant who needs his pet rescued or kill more poachers. That's all you'll get.
The motivation to do these menial side missions is even lower due to the interchangeably awful voice acting and writing. It feels like if it’s not the writing that’s off, it’s the acting and vice versa. I would say the acting isn’t as bad as it could’ve been, but the writing reaches lower echelon Bethesda more often than not.

- The HUD is cluttered and breaks immersion.
- No memorable characters besides Sebastian.
- No matter the graphical settings, the game has issues around Hogwarts and especially Hogsmead. Lots of stuttering, textures loading in late, so on and so forth. It's got technical issues still as of June 2023.

Conclusion:
Despite most of its flaws and shortcomings Hogwarts Legacy is a strong game that many people will grow fond of.
It does the main part right: gameplay, decent story, graphics and depicts the world of Harry Potter better than other harry potter games.
I strongly believe it wouldn't have been as successful if it weren't for huge controversies or if it didn't have the Harry Potter theme around it.

It's a 7.8 / 10