1. The Drive Unit problems are probably not that big of a worry, as most of the issues are just noisy DU's due to very wide manufacturing and assembly tolerances. The drive units are also plentiful and cheap used, because Tesla is hostile to owners of salvage(and non-salvage for that matter) cars.
2. Working on the Model S is pretty easy for people experienced in that field. The big snag is getting parts, and access to firmware/diagnostic menu. This will change in time, as I can't see this monopoly lasting long.
3. The vampire load is due to connectivity/BMS. It doesn't have to be that way(Rav4 EV isn't), but it's a decision Tesla has made most likely due to information gathering(the car uploads the logs every couple of weeks).
These are worries because to me the future is unknown and they are unsolved.
Noise? I don't know, when I read the reports I see a lot of dead drives with cars needing towing. Noise is unacceptable too in any event. I can understand a 250k mile unit maybe being a little noisy, but the expectation is that this just shouldn't happen. Elon has thrown around his "Million mile" drivetrain thing more than once, and most recently during the Ludicrous announcement, I might add. Drive unit failures for other EV makes don't seem to be statistically relevant. (except for those w/ Tesla DT's!) Even on systems as complex as the Prius and the Volt with all the extra mechanical systems, they seem solid.
Yes, I've been able to get into my car easily. It's built using methods common to other cars. But ALL those other cars also have manuals! How do you know it will change in time? Yes, the monopoly could even end with Tesla going under, then still no parts! Not a comfort to me!
I know exactly what's causing the Vampire load, and it isn't the logging. That's done by a separate system (The Gateway). The RAV4 EV has almost the same gateway and almost identical BMS. What it doesn't have is the big touchscreen that is kept constantly powered to some degree all the time. Tablets using the Tegra3 can idle on tiny internal Lithium-Polymer cells, why can't Tesla's? (And I know the answer to this too, which is why I'm worried)
Don't take this as Tesla bashing. I support Tesla fully, but there are definitely areas needing improvements!