What is the origin behind illogical puzzles in video games?

There have been some puzzles which did not, by any means, make any sense whatsoever and I couldn’t understand why I had to that in order to get to where I needed to be. I could’ve easily achieved my purpose without the silly puzzle.

For ex: (possible spoilers)

Uninvited NES: There’s a spider you must catch and in order to do so, you must first spray the railing it’s crawling on to stop it from crawling any further. After you leave the room and come back, the spider is frozen in place and you’re then free to take it. Also, at first glance, there’s no indication that the spider serves a later purpose in the game and what you have to do TO the spider to capture it.

I enjoy playing video games, but sometimes I’m just so confused as to why some of these puzzles even exist.