Fist, I don't want to work with a group of people who have only been selected by their ability to solve stupid, meaningless puzzles. That's something you do in college, which I hated.
Second, once you get past a minimum level of intelligence a lot of success in software development is based on motivation. It's hard to be motivated by a made-up problem where all your hard work is going to be thrown away and not used by anyone for anything, and my first step in solving it is to involuntarily roll my eyes and groan. That starts the project off on a bad foot to begin with.
Different people like different kinds of puzzles. I like Fermi-type problems, which at least at one time, it seemed like everyone on the internet liked to bash. It may be they are no longer bashed because interviewers abandoned them.
I once posted a puzzle on a different website that boiled down to "why did I choose this particular non-round number" with some context, and eventually someone got it, but some people got very angry at me.
The trouble is that a lot of puzzles reduce to "can you follow a particular convoluted path to a solution" and if you don't, you are being judged unworthy for being dissimilar in your thinking and not necessarily for your sheer brainpower.
That's why I prefer puzzles that nobody has solved, but those have two obvious problems - either (a) they are too hard to solve, or (b) once solved, they appear to be too easy. Either way, you can't use them as tests.
It's natural to like tests that you are good at and other people are not, and to hate tests that other people are good at and you are not. So, people are always going to take offense at tests.
Second, once you get past a minimum level of intelligence a lot of success in software development is based on motivation. It's hard to be motivated by a made-up problem where all your hard work is going to be thrown away and not used by anyone for anything, and my first step in solving it is to involuntarily roll my eyes and groan. That starts the project off on a bad foot to begin with.