"hundred of hours of gameplay" means you'll spend most of your time doing nothing just searching for actual content. rarely does an open world ever improve a game. The only two cases i can think of are GTA and Insomniac's Spider-man.
So few cases of open world being a positive. Near enough every one of them has a focus on 'exploring' the world and crafting useless shite every 10 minutes.
Most game design can be done poorly and well. Open world is just a popular thing people like. They want to explore and make their own adventure. Designing a well structured open world is good. Sandboxes without fun tools are not. In my opinion
Every Fallout could be argued to have "open world." I think that the opening act of Fallout 1 and New Vegas are good open world design. Nothing groundbreaking but open world done right.
I've never played Gothic but I've been told its open world is smaller and well designed in comparison to modern titles which are literal sandboxes.
fallout 1 and 2 don't have open worlds. they have an overworld and some hubs. and i'd argue that almost every open world rpg would be ridiculously better if they did that instead of having so much negative space.