Also, software development lifecycle tools surrounding stored procedures aren't as mature: unit testing tools, automated builds, linters, etc.

This puts them on more-or-less the same level as shell scripts to me. They're fine if they're tiny, in source control, and unsurprising.