Might one objection to SP's be that they hurt your ability to migrate from one DB to another? I've never worked anywhere where SP's were widely used, and the chief argument has always been along the lines of "what if we switch to another database? We'll have to rewrite all this logic if it's in stored procedures."
Do you agree with this limitation? Does it change your thinking on the subject?