Anecdotal: I experienced this doing stronglifts 5x5, which is a program that systematically keeps you lifting near your 5 rep max. Squats in particular seem to mess up my CNS. Moderate weight lifting is awesome for my mood and cognition, heavy weightlifting is destabilizing.