>>713890932I'd argue that Golarion can never be great because, try as they may (and they have tried), they can never fully tie together the kitchensink setting they have created with a consistent theme. But I wouldn't call it the worst either, exactly because there are so many places inside that setting that allow you to tailor a campaign however you like.
Want gothic shit? Try Ustalav.
Want pirate/swashbucking shit? Try The Shackles
Want ancient Egypt shit? Try Osirion.
Want Asian shit? Try Tian Xia (for China) and Minkai (for Japan).
And the list goes on.
It's flexible for a DM that doesn't want the colossal work of homebrewing an entire region and its background.