The remaining weakness will come from the failure of our logic system to have a sixth logic operator that naturally supports error correction. Something like this must run incomprehensibly off the rails. This will provide a serious limit. Now is when it needed to be built in to the chips themselves.
Computing itself will never be the same and it is not that everything is obsolete so much as smarter solutions are on the way should your needs require it.
“ To underscore this divergence between the brain and today’s computers, note that a 'human-scale' simulation with 100 trillion synapses required 96 Blue Gene/Q racks of the Lawrence Livermore National Lab Sequoia supercomputer ”