I've never seen anybody here assert that SPs are of no use. hmmm....not totally sure about that....that "almost" makes me want to do a few post searches.
It's the use on every occasion that causes dissent. This may come as a surprise to you, but in the end, I am a pragmatist. I feel like I'm repeating myself twice today, but I've never said they should be used 100% of the time....I advocate them as a starting point, unless there are specific reasons not to.
And I'm amused at responses along the lines of, 'well, you must have been doing VB style VFP apps, you couldn't have been doing intensive data apps in fox', etc.