I loved exploring Hogwarts tht definitely wasn't a gripe for me but the repitiveness of the enemies got to me.Don't agree with some of your examples, but in general I agree.
RDR2 and Elden Ring for example, are some games I liked, but the open world bloat really impacted them negatively and made the experience feel a few step backwards in respect to their predecessors.
Hogwarts too would have been an even greater experience with a smaller map.