Website, DB, & Software Developers

I've 'surveyed' the programming community (Google searched) and there seems to be a great consensus that stored procedures in an inappropriate place for business logic. I feel like it's 1999 when I'm doing that much coding in T-Sql. It's so easy to make a mistake that gets buried, there's no connection to the real world logic like there is with actual OOP objects, and for seemingly every function requires a new SP to be written, whereas with an OOP object, it can just be extended, or new objects can be added until you eventually have a machine that fits together perfectly running like a Ferrari.