I thought Hogwarts Legacy was a misfire -- it's not bad, it's just... misguided. Hogwarts and Hogsmeade are by far the best part of the game, but very little of the story actually takes place there, and most of the students/professors are just set dressing. There are only a handful of characters with any personality.
It was also a wild choice to have a 15 year old killing literally hundreds of goblins and wizards.
It would have been a much better game with a smaller focus on just being a student at Hogwarts, with trips to Hogsmeade and possibly a few excursions elsewhere (like Diagon Alley). Hogwarts Castle is fantastically detailed, full of all the nooks and crannies you'd hope for, and it's barely utilized.
Regardless, it was obviously incredibly successful, even if the game itself doesn't live up to the sales figures IMO.