Good work.
I have used "SQL making SQL" before in generating audit trail triggers.
Security needs to be addressed as well, by adding grants at the end.
Maybe pull the rights from the underlying table, and/or from the rights on the existing proc (to preserve that when regenerating)