But to your point specifically, in the podcast, I believe the guy was able to play the piano quite soon (I think days or weeks after his accident).
So to me, this points not to just an Adderall-like mental state, but an enhancement (though, sure, due to a compensation of one part of the brain for the damaged part).
To me, it feels like there are triggers or switches that perhaps optimize for certain tasks, or, it's the real default, and it's the majority of us who are off. But it's tough to guess what, if any, are the trade offs, other than potential brain damage, I guess. But it deeply intrigues me to think about what else we'll be unlocking in ourselves in the future.