I would wager that it is far more common for people to consider confusion a negative thing than a positive thing.
If you asked a sample of people if they thought confusion felt mostly pleasant or mostly unpleasant, I think the majority of replies would be that it's an unpleasant experience.
So I don't think you're alone. I think the ability to tolerate ambiguity and confusion is a tremendously useful skill, but it's awfully rare.
