I'm very confused now!
I simply think if I go away for 7-10 days and park my Aero outside in a hotel car with little or no use, I will Not be confident the current spec battery will hold up so surely a higher capacity battery will take longer to go flat solving my concern.
I have all my cars on trickle Ctek chargers at home.
You're quite right.
Fit a larger capacity battery and you'll be able to leave the car idle for a longer period without suffering from a flat battery.
There are some very high performing batteries available, but of course they're more expensive. Example ..
https://advancedbatterysupplies.co.uk/agm-batteries/https://www.consumerreports.org/cro/car-batteries/buying-guide