I don’t mind very light and simple puzzles.
It’s very easy for stuff to get out of hand though.
The airlock puzzles in one of the Persona 5 dungeons and that puzzle you have to do in Twilight princess before you get the Master Sword are some of the worst I’ve played.
Puzzles that take out of the game and force you to finish to progress through the game are terrible, especially if the don’t actually have you make use of the game’s mechanics.
Optional or side quests I’m usually ok with, but mandatory puzzles can get fucked unless the game is built around them like the Witness.