> I understand textpattern might allow editing designs from the UI as well though?

Yes, everything is stored in the database, and Textpattern has an integrated text editor for templates and CSS, with a rudimentary form builder (basically search for txp tags and drag them in).