So is the main risk simply a flat battery?
That depends on which radio you are looking at.
The RMT-300 appears to have power circuits like aftermarket radios. One circuit to supply power all the time and another switched with the ignition so the radio knows when it is to turn on/off automatically. There shouldn't be any issues with battery drain there unless you wired it up to run all the time and forgot to turn it off.
The RCN-215 uses the Convenience CAN BUS (which is tapped from the HVAC controls) to know when to turn on/off with the ignition (and turn Bluetooth on/off), when and what level to set backlighting, to get speed information for the speed dependent volume control, and allow steering wheel control signals. I've not heard of anyone having battery drain issues with this radio.
The RCD-330 is a newer radio, and while I've not done enough digging into it I suspect it could range from the same issue as the newer RCD-510, RNS-315, and RNS-510 can have in A5 cars. Those radios talk over the Entertainment (Infotainment) CAN BUS, and there is more data going over that than what the RCN-215 does. These radios can prevent the CAN BUS from going into sleep mode when the car is off, resulting in a dead battery in a day or two. This can be corrected with an updated CAN Gateway module. Of note, this problem doesn't happen with all older generation cars. I have the RNS-315 in mine now and have not upgraded the Gateway module with no battery drain issue.