A middle option, and one that I use, is to run DNS-over-HTTPS on my pi-hole machine to tunnel DNS out. Without DNS information the local ISP can tell a lot less about the sites I'm visiting, since many sites are behind the same CDN IP pools.