Anything we can do to encourage procs, the better. But, with the movement towards the use of object abstraction tools such as NHibernate, Linq, and MyGenerate, I fear the battle against code generated, dynamic queries will only get more difficult. Many, like EntitySpace, encourage the use of stored procedures for CRUD operations, but Hibernate does not.
The more you are prepared, the less you need it.