This is so awesome.

Can you setup wildcards? Like for example *.[name].san-fransisco.ca.us? That way I can do this once for my own name and have it setup for all future needs as well.

Yes. The registrar is for the root domain. You provide your own DNS. DNS can do wildcards for any root domain its delegated.