I completely agree, technology is a lot like time & money. Throw enough of it at any problem and you'll likely solve it.

When dealing with scale problems, the biggest asset is flexibility as you will likely need more than one kind of "database" and your logic layer will be the glue that holds it all together.

Stored procedures are simply too focused a tool and often tied to a particular database to offer any comprehensive solutions.