>> Or am I being too idealistic?
Yes IMO. The use of stored procedure is considered a best practice for a number of reasons, some of which are the ones that you're struggling with. I always use stored procedures for all data retrival and manipulation.
-Mike