Chantal Borciani shortlists the top late-season city breaks that offer sunshine and good times