At the risk of boring people (as I may have mentioned this before), I have a 1978 Gibson G-3. Three single coil pickups. Volume, tone and 3 way selector which does neck/middle, all three and middle/bridge respectively. Like: the basic tone (particularly low down), the looks, the chunky neck, the fact that it's not a Fender. Dislike: only 20 frets, pearl dots on a maple board are very hard to see, neck dive if you don't use a grippy strap (fine with), limited variation considering there's three pickups on offer.
Also had a Danelectro Hodad. Three single coil lipstick pickups. Full seven way switching and concentric vol/tone. Like: the flexibility of tones (although I have to say that the individual pickups are a bit weak on their own - I usually used one of the double combinations or all three), light (semi hollow), nice neck, the fact that it's not a Fender. Dislike: only 20 frets, neck dive impossible to avoid because of light body, all or nothing tone pot.
When it comes to three pickups having an impact upon sustain, you have to balance out that these are single coil pickups, so probably less magnetism going around per unit. I haven't thought about it much though, because note sustain isn't something that concerns me a great deal. As long as the notes aren't decaying like a 70s Alfa then I'm happy