There's also a great Star Trek episode, the Nth Degree, where Barclay becomes the smartest man alive. The cast is typically annoyed with him so it's great to see the looks of admiration in their faces as he's suddenly able to solve engineering problems faster than Data, brings Beverly to tears in an acting scene they perform together and is confident enough to "make a pass" at Troi.