DBA Review is a must!
As a DBA, I would not feel so comfortable when developers upload their modifications directly to Production databases. I must be able to review the changes they are willing to do. Most of the developers are not aware of Index Tuning, T-SQL Best Practices etc. unfortunately...
Andy Weedman commented
Not only would this be nice for DBA review but I don't feel comfortable with anything touching production unless eyes review the genereated script before it runs. I agree it would be nice to setup a gate around certain environments that would all for a manual review and separate click before proceeding.