The Yakuza games are packed full of content in a small world. To some degree Baldur's Gate 3 also has this mentality and it expands on the hub maps with verticality of enviroments.
The only somewhat decent open worlds are Far Cry 2 but that's because of the realism it was back then.
Witcher...