I read somewhere that Adderall does not improve cognitive function in people without ADHD and in some cases can even decrease it.

Have you ever taken a decent dose of an amphetamine? It isn't going to make you smarter but it will almost certainly boost your energy and ability to get stuff done.