It's def not "Raw mental horsepower" it's more knowing an obscure algorithmic trick.
The furthest I've ever seen it go in practice: binary search, BFS/DFS, hash tables. I've never seen any more obscure algorithmic trick than standard uses of these algorithms and data structures.
I'm not saying leetcode doesn't have more insane questions, but interviews tend to be straightforward.