I actually can enjoy riddles and logic puzzles, and don't think a game would feel like D&D or BG without at least a few. But I agree they can be dreadful if done badly.
I've just played Pathfinder WotR and found the puzzles awful, or at least the interface and visibility was, such as slab placement puzzles where I couldn't see the puzzle at the same time as the slab I was picking. But even once I'd got the solution in front of me (and I absolutely used cheats from the internet) I usually couldn't see how I was meant to have worked it out unless it was largely by trial and error, though perhaps I was simply being dim. Also in WotR even with the puzzles where we were given clues, I often only came across the clue after the puzzle, and though I guess the fact that frequently I'd already cheated it was on me, I also blame the game for not giving me the confidence that it would give me the key bits of info to solve the puzzle if only I were patient.
Anyway, now I've got that off my chest, I definitely prefer puzzles that don't involve too much trial and error, only reasoning, once you've worked out what you're trying to achieve, and that try to give you a decent hint of what that is (that you find near or before the puzzle or in a place that it makes sense to find it, if it's not something you can work out from the puzzle itself).
The only real example I can think of from BG3 EA - the moon puzzle under the shattered sanctum - isn't a hugely promising indicator, but it's not terrible either. There is a decent hint at roughly what you're trying to do, but I found it ambiguous as to which way up I was meant to be solving the puzzle, at least until I spotted some stylized stars that I missed on many playthroughs. And having "solved" the puzzle the wrong way up it's easy to lose heart and decide you're on the wrong track. But on the other hand, with a successful perception check from one of your party you can find a lever that you can lockpick to avoid having to solve it at all. Mixed messages so far, I'd say, so we'll need to wait and see!
"You may call it 'nonsense' if you like, but I've heard nonsense, compared with which that would be as sensible as a dictionary!"
