I personally always really liked the games. Like the first three on PC (the PS2 versions seem good as well, I just had the PC versions), and those had the huge advantage of being scored by Jeremy Soule.

And I gotta say, the environment artists on Hogwarts Legacy really knocked it out of the park. I've watched some streams and videos and the castle and Hogsmeade look really cool.