Quantum rotor theory of spinor condensates in tight traps