There are several limits on overall computational performance besides switching speed of and power consumption of an individual transistor.
Number of parallel processing elements and the degree to which code can harness these is also a major factor. Ultimately this is limited by Amdahl’s Law, even given an infinite number of CPU cores which have zero hardware synchronization overhead. In short, the potential parallel speedup is quickly “poisoned” by a small % of serializable code: Amdahl's law - Wikipedia
A specific common example of this is H.264 video encoding which cannot be significantly accelerated with GPU methods because the core algorithm is inherently sequential.
Another factor is how much instruction-level parallelism can be placed in code and the limits on extracting this in a superscalar CPU core: Instruction-level parallelism - Wikipedia
Superscalar processor - Wikipedia
Although the human brain is often compared to a computer (in fact early computers were called “electronic brains”), this is misleading and implies a similarity between transistors and neurons. It also implies that human memory is stored in a discrete subsystem like computer memory.
Decades ago, the brain was often compared to a great telephone switchboard. This arose before computers were widespread. In that era a switchboard was the most complex commonly-understood device which had some vague similarity to then-envisioned brain function.
In fact the brain is nothing like a switchboard and maybe it is less like a computer than we think. The problem is nobody really knows how memories are stored or how biological function at a neuronal or higher level gives rise to thought.
For people who are geniuses or have perfect memory, nobody knows how their brains differ to produce these higher performance levels. Therefore it is impossible to say what the limiting factors are for brain function.
Despite tremendous amounts of research, the underlying biological basis for disorders like clinical depression is not known. It is almost certainly not rooted in a neurotransmitter issue at the synaptic level. Some studies show it may be rooted in a deficiency in neuroplasticity: Stress, Depression, and Neuroplasticity: A Convergence of Mechanisms | Neuropsychopharmacology
Whoever figures that out will probably win a Nobel prize. The fact nobody has shows how limited our knowledge of brain function is, so we really don’t know what limits brain performance.