Sure, many admonish stored procs. There are also people who claim that .NET can't do data munging. Trying to lend respectability to a point, by demonstrating google hits, is pretty unsophisticated.
I've found that in the 'academic' world, the number of people who advocate SPs is greater than the number who reject them. Not by a huge amount, but definitely greater. In client sites [i.e., outside of academia], I find that SPs are heavily embraced. Why do you suppose that is?
I know of multiple installations that generate at least 3 stored procedures per table as a practice.
I've read just about everything that you and JVP have said on the subject.
On your last point, just because something is 'daunting' to one ascending the learning curve, doesn't mean it's not practical. If one is using some kind of managed methodology for doing so, the number [900, or whatever] will often be irrelevant.
Kevin