This is exactly the crux of it: Dns services are no different than VPNs - there is no one service that unlocks everything with high quality across the board.
I am personally using 3 different ones at the moment (ControlD, Getflix, and DNS4Me) which give me the right services at the quality I want. In my setup I use AdGuard Home on my router to “triage” which URLs go to which dns service - similar to split tunneling with VPNs. That way I avoid having to switch VPNs or servers and it’s pretty much set and forget as long as there aren’t outages (which I have redundancies for across my dns services if need be)