I think the Map of the castle is absolutely exceptional and there's a lot of attention to detail.
The main storyline is enjoyable enough, although I wish there was more of a push-back if you choose to use the unforgivable curses. They're meant to be unforgivable and yet you pretty much get a "oh I wish you wouldn't do that" when you straight up torture an enemy in front of an NPC.
The main letdown for me is that outside of the castle, a lot of the game feels somewhat empty. It's not like Skyrim where you go out into the world and you're always finding little things spread out everywhere that piques your interest. It feels like there's not much reason to venture out from the castle or Hogsmeade unless a mission explicitly tells you to.
Overall though I do think it's decent.