We enjoyed a trip to a hotel with onsite waterpark and aircon in Paphos last year.
Have you been anywhere Meditteranean that you'd highly recommend to go with a 9 yr old?
Ideally: kids club, onsite or fairly close waterpark, decent varied food, some evening entertainment. Comfortable and air con is now an essential, I slept so much better.