Well, after posting in here a couple of years ago, I've finally bitten the bullet and got it sorted.
Very simple multi-split setup. Two indoor units, one in the main bedroom and one in the second bedroom which is my home office and one outdoor unit on the back of the house just above a flat roof.
Don't really need anything else as downstairs never gets that hot, it's upstairs that's the problem.
Easier to justify now I'm generally WFH four days a week. Some friends have asked why it's worth it when we "only have a few weeks of hot weather per year" but my home office in particular is a problem even when it's only 24/25C outside, due to the sun shining on the window in the afternoons and computers and monitors pumping out heat. It's regularly 5C hotter in here than the outside ambient.
Will also be interesting to see how it fares for heating in the winter. As I live alone, I don't need to heat the whole house when I'm in one room all day so often resort to a small convection heater to just take the chill off the office. I'm expecting the AC unit to be a bit more efficient at this.
Of course I am away that the weather has now packed up and that it's entirely my fault. There will now be no more hot weather for the remainder of the year