> what happens if you get unlucky and are at fault with a top end Lamborghini
That would be liability insurance, not comprehensive, wouldn't it? Comprehensive insurance covers damage to your car (could be glass, vandals, natural events, hitting something with your bumper, etc.)
At least in my country, at fault accidents give you a worse premium for the next few years (one or two right now, but more than ten if I had an accident on the years immediately after I got my first insurance). So you would still end up paying something.
That would be liability insurance, not comprehensive, wouldn't it? Comprehensive insurance covers damage to your car (could be glass, vandals, natural events, hitting something with your bumper, etc.)