The problem I find with developers creating stored procedures is the need to have database owner authority.  I promote the stored procedures to production but they have full control in development. 

I wish SQL Server had an authority just for Stored Procedure development.