>>I use a lot of SPs and so do a lot of other people that hit the data I find I need to have the backend handle a lot - especially defaults

Yes, if several people share SP's then the defaults make sense.

My first .NET apps used SP's almost exclusively as I did with VFP but I've moved toward doing more in the middle tier because I have to be there anyway and the datasets are so slick to work with.