See, really even options are silly. They are better than I can't do the compsci101 towers of hanoi puzzle but in reality you are again displacing your character's ability for your own in doing the puzzles. Why have a lockpicking skill why not just let players pick a lock? Why have PC driven combat instead just let the player handle comba. Obbviously something, like Syrim did the latter 2 which is why those games annoying the hades out of me because my character is really not all that important to my success in the game.
I'd say these games are about testing player skill with some modification based on their character design. If not, all combat would be auto resolved by the numbers without any pesky player intervention. Personally I get more satisfaction from a combination of designing a good character and then playing it well rather than have things be purely dependent on the character design. The problem with riddles though is they end up being entirely based on the player. Even lock picking mini games can be made easier or harder based on character stats, but riddles are trickier. I suppose you could factor in character traits and skills affecting the information you receive to solve them.
Now personally I think a couple of lightweight riddles/ logic puzzles are a nice change of pace, but then I think back to the days of unexpected shooter mini games in my RPGs and feel more sympathetic towards people who dislike them.
To anyone after something needing serious thought though, I recommend giving The Secret World a spin. There's some wonderful little brain teasers in there.