"Nobody is calling spending weeks writing a caching layer for a 20-row database "elegant" or "best practice"

I don't disagree with your main points, but you might be surprised to hear some things that people will say and unnecessary optimizations they'll attempt...