I think stored procedures have more going for them than against them:

Portability

The notion of procs not being portable I think goes back to most developers beliving its safest to stick...