Backups and restores are too complicated. It's as if it has been created that way to make sure DBAs keep control of such areas, but I imagine it is just because there hasn't been an obvious need or demand (in the eyes of Microsoft) to make it simpler.

Many moons ago I worked for a company that had an inordinate number of small customers scattered across the country, all with SS 2000 MSDE installed. I wrote a VB/SQL DMO package that controlled the backups and controlled the restores if required - prompting the users for the correct disks. They had to get a password from us if they thought they needed to restore as it's surprising just how often they'd panic and want to do such a thing for no good reason, but it was as automated as it was sensibly possible to make it.