I have a 1.5kW air cooled spindle and have no issues at all with it. As far as I can tell the main reason to go water cooled is the reduction in noise compared to the air cooled version
I was getting some pretty sh*ty results and snapping bits with no explanation. After investigating further I found out my water pump had died. No explanation or reason just dead.