Why go so far as using a sproc? Couldn't you get the same from a view?
Discussion
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.