ORM.Net is a pretty cool looking tool that builds a framework for accessing data w/o SPs.
It might be bad in that you would have all this propritary code in your product, so if you wanted to move away from it later, you would have to rewrite a bunch of stuff.