The big issue tends to be complex logic for going to sleep often getting stuck. Ie. "oh, I was trying to use the LTE connection to poll for updates, but the connection got reset so I kept the CPU awake forever whilst retrying every 5 minutes rather than going to sleep mode".

Older cars had this too - I had a bunch of cars which would kill their own batteries if not locked - the engineers assumed that all owners lock the car when walking away, which often isn't the case in your own garage.

It's not, but older cars tried to keep their batteries fully charged. Newer cars with the so-called "smart" alternators never keep the battery full, they always leave some empty capacity to recover energy while moving.

I haven't found any appreciable drain on my EV's primary battery over the longest period I've left it sitting so far (a little over a week, so not that long, admittedly), but the car _does_ do a very bad job of keeping the 12V battery charged and I've already had to replace it once in <2 years of ownership, plus I bought one of those small jump start packs in case it ever dies not at home (luckily, for an EV, it barely requires any power at all to turn everything on and get it started, so the very smallest, cheapest, jump packs are way more than sufficient). A built in trickle charger to combat that would indeed be nice, if the car companies are incapable of figuring out the logic necessary to do it off of the massive primary battery.