The "art" is repulsive as well.

Build a users table with a primary key and twenty single-column indexes

That's pretty bad

(I have seen worse in production, and so have you)

but yes, yes I have.

I have a hard time believing acquiring so many locks you don't need is particularly harmless. Won't every single one of those introduce a memory fence? Which will then stall out every CPU core on the server.