It all depends what your price range is, and what you're looking for. I like the way low output pickups respond with distortions and fuzz. But also high output pickups give you a lot from the guitar.
Low output - known for more vintage sounds, typically brighter sounding, less compressed, won't push amp as hard (thus yielding more headroom before overdriven), very dynamic and sensitive to playing, less sustain, typically "open" sounding
High output - known for more modern sounds, typically the hotter the darker it will get, will drive amp earlier, more focused bass and mids, more compressed, less dynamic but more consistent tones, more sustain, typically "tight" sounding
I really have both sides of the argument because I own a 2000s MusicMan StingRay and a 70s Gibson Grabber. I have found that if you use a lot of pedals, low output caters a lot better. The high output of the MM is better for the straight rocking music where I don't want to be all over with the dynamics and overdrives, distortion, and fuzz pedals. The Grabber worked great for my band which had volume changes all over and lots of clean to fuzztone sounds. For me, a low output humbucker does it best. Just enough output and body, responsive yet tight.
Hopefully this helps and doesn't confuse more.
Just play many different things and find what works for you.
