Tom, I agree strongly with you. I favour moving as much application business logic into stored procedures as is possible, thereby abstracting out the UI layer from the business logic. And our shop uses UDFs frequently as well as sprocs, so as to maximise our code reuse.

Like you, it puzzles me to see these practises less widely adopted elsewhere than I do.