1) DNS has nothing to do with HTTP, wrong service. Look at using bind or djbdns (if you're daring).
2) It depends on the purpose. If you want to create subdomains for the user you should offer the option of creating the hosts for them (IN A records) or giving them control of the subdomain (IN NS)
3) What is a zone priority? Wildcards apply if the host is not defined, then default to the wildcard. If you define a subdomain then it resolves as defined, if not it falls back on the wildcard
4) That is not the right approach. DNS functions whether or not a website is down. What you want is a high-availability website. For this you are best to get a paid service, but effectively you can just get a single high throughput line with one IP and pass it off to a load balanced server cluster. At that point you can apply updates and such to one server at a time without disrupting traffic.
5) Why setup a failsafe? If you can serve any content, you should be serving the sites' content. Please see #4
Not being critical but matter-of-fact: you're having a hard time separating what is DNS versus what is HTTP/web services. DNS defines IP addresses to go to, nothing more nothing less. A level of complexity is added with doing the slave configurations you're talking about but its still possible and done today.