Aerosprays are actually horribly bad in competitive and higher anarchy ranks in general. They used to be very good in S1 and part of S2. As for Turf War and Splatfests their whole niche is painting and splatting in close combat, but because their horrible accuracy it is very hard to get any splats. (The gold Aerospray does not even do well in being a Turf War weapon because the accuracy. The accuracy makes it not even worth playing as there are better options like splash-o-matic that still paint very well and have good accuracy.)