Stored Procedures Suxorz

Ever since the first time I heard and learned about stored procedures, I have always questioned their value. From the beginning it just seemed like the most unnatural way to achieve my desired result. But, I followed the commands from the higher-ups and tried as best I could to buy into their philosophy that stored procedures are from God and your code sucks if you don't use them. I'm the type of person that has to find out stuff on my own. In other words, if someone calls something a spade, and I don't think it looks/acts/smells like a spade - then I'm going to investigate. Then I found out that there are plenty of other folks who don't buy into the stored procedure philosophy:

http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx
http://www.codinghorror.com/blog/archives/000117.html

These guys draw out all of the points that I have made to other developers who seem to have this unhealthy obsession with using stored procs.