If something goes wrong and our learned rules and basic instincts aren’t working, consciousness has to step in and try to cobble a solution together on the fly (usually badly).
Considering that we’ve so completely kicked ass against any other species that we haven’t been even on the same playing field for thousands of years I’d say conciousness has done rather well for itself.
Ofcourse this is just in relation to other species, in absolute scale we probably are not that good.
Extrapolating from the trend it would not suprise me greatly if we’d eventually find out that intelligence in general is not as interesting as we thought.
When something is actually understood the problem suffers from rainbow effect “Oh it’s just reflected light from water droplets, how boring and not interesting at all”. It becomes a common thing thus boring for some. I, for one, think go and chess are much more interesting games now that we actually know how they are played, not just how to play.