I don't mind some puzzles and hard-to-spot secrets too much, but only when not done in an obnoxious way. I agree that in general it doesn't make sense to be forced into playing a hidden object game when you're pretty sure you purchased a RPG. Having to hover my house over every pixel in the screen and walk through every pixel of the map to force repeated perception checks on my characters is just unfun , dull and tedious and whoever thinks that is an attractive mechanic has no business in the entertainment industry.
It is funny because when you roleplay a very strong character, you are not expected to be buff and 'roided up in real life to allow your character to push a huge boulder down a hill, but in the flipside, seems that even if you're playing a high intelligence character, sometimes you're expected to actually do mental gymnastics to the point of getting migraines to come up with the solution to arbitrary riddles/secret doors that my superintelligent/observant character should be able to deal with without my help, the same way I wasn't requested by the game to do some pushups before my strength based character pushed the boulder down the hill.