Someone once told me that fish are stupid, and they'll try to eat the air bubbles from an airstone. I guess this isn't good.
(Probably gives them gas or something! )

I've never used one in my tank. Don't see why you couldn't have one in a sump, though, to get better oxygen exchange.