I guess every situation is going to present different needs. Stored procs afford some semblence of upfront constraints on what can be interrogated and a logic point for short circuiting.