Having been rained on in Crete and chilly in the Costa del Sol, our writer reveals her go-to destination for guaranteed sunshine in September and beyond