>If you depend solely on SPs for your backend, the middle-tier would be at the
> very least redundant, and at the very worst, ignored.

Huh? what school of DB design and application development taught you this?

Middle tier is primarily for load managementand business rule enforcement. What the heck does that have to do with SP or not on BE?