If you are looking for a fat, warm or even Chrunchy or really heavy sound...then humbuckers are best.
Single coils tend to be more diverse, but less heavy and less effective with overdrive. The there are p-90s or soapbars, which have only one coil, but are kind of in between.