I think this hard problem has a simple answer that people just don’t like: consciousness is a powerful (and fundamental to our "calculator brain") illusion. And yes, a spreadsheet simulating every neuron in your brain would also simulate it. The fact that it’s difficult to conceptualize doesn’t mean it’s not
the answer. Similar to how we struggle to intuit general relativity, or to imagine the pre–Big Bang state of the universe (or its non-existence), or to picture what it’s like to be dead. Our intuition simply isn’t equipped for these cases, period, and it pushes back hard against them. Consciousness belongs in that same category IMO
Also, the emergence of a consciousness like illusion kinda follows from an evolutionary perspective. To survive, a "calculator" brain needs a model of the external world in order to predict how it will evolve and to act in ways that improve survival odds. Once such a model exists, it becomes almost inevitable that it also includes a model of the system itself, since the brain is also part of the world it is modeling and an agent within it. This self-referential loop is likely what we experience as "consciousness" and it becomes central to how we understand and navigate reality.
If we accept this framing, many traditional paradoxes dissolve on their own. The problem stops being "hard" in substance and becomes hard only in terms of imagination.