I sometimes prefer watching "The Cage" over "The Menagerie". There's a little more footage, and it's useful as a historical document for Roddenberry's attempt at getting his idea sold.
I wonder, did we ever get a replacement for Number One? In any series?
In terms of a super-smart, logical first officer, Spock and T'Pol. In terms of a female first officer, the closest things are Major Kira and T'Pol.