Well the functionality is not too hard, you could either use SMO, which is effectively the API for SSMS (actually, it is the management API for SQL Server, which SSMS uses) or you could write a series of stored procedures to give a relatively unprivileged and non-technical user the ability to do this.

What is a lot trickier is the user interface. There are no forms or graphical input capabilities built in to SQL Server (or SSMS), you have to either write client code or just use an existing interface like SSMS. You could just train your user to use the stored procs mentioned above, but this is not very visual.

The alternative would be to write your own GUI using C# or VB.net. It sounds like an interesting project/utility though, something that might be reusable for many other SQL Server customers.