For lifting you hit a saturation point quickly where your muscles will only hold so much of it. Not sure if there is an equivalent for any brain related effects.
I'm sure there's something for the brain too. The thing is, there's a floor for the brain. If your muscles aren't saturated already and you don't "megadose" (from a muscle perspective) then you won't see any cognitive effects it seems.