I try and keep mine small, but have seen some truly horrendous ones in my time that nobody seems to actually understand.

But this is really a performance vs scalability question. You are pushing scalability but there are times where scalability isn't needed but performance is, and putting all the logic into a stored proc that gets called once rather than artificially using multiple stored proc invocations can make for much better performance.