"The nature of consciousness"? That's ambiguous - but, No, not the nature of consciousness as most would interpret it.
But quantum super-positioning is the only mechanism in Physics for holding a non-trivial amount of information in a single state - and most people would claim that their experience of "consciousness" includes that ability.
So, as far as Chalmer's Hard Problem" is concerned, it divides the question - isolating the "hard" part to unexplained (and likely unexplainable) Physics while leaving the rest as a kind of biology engineering problem.
From the OP: "Could every thought/ action be a resolution of superpositions?"
This gets into the "engineering" part. Penrose and Hameroff described the consciousness process as occurring across neurons via the microtubules that you mentioned. They also seemed to buy into the notion that people are of one mind. I suggest that we consist of many such quantum "circuits", each attempting to find a high-scoring "plan", but only one such plan-inventor gets to write to our story at a time and the "plan" is further censored by classical circuitry before being implemented. I'm also not on board with those microtubules.
At this point, the main purpose of trying to work out how consciousness works and what mechanisms could support it is to give those working with live brains (mostly animals brains, I hope) a notion of what to look for and where to look for it.