I haven't come across a pickup which can do everything from blues/pop/rock/alternative/metal. It's good at one or the other, or else it's a compromise which doesn't excel at anything.
If you want hard rock / metal, you have no choice but to go humbucker. Apart from Adrian Smith and Dave Murray, I haven't seen many others play hard rock / metal with fenders.
If you want the sweetest sounding single coils, I recommend the Van Zandt blues pickups - I have them on my strat and they flat out rock. You may also want to take a look at Wolfetone pickups (you have to special order them from the US but worth every penny) - you can use "cub"s in the neck and middle and the "bitch" in the bridge position. I've played that combo and it rocks.