Commander in undercover unit convinced female officer that they were to pretend to be lovers on secret mission, then kissed and groped her; police say he has been booted from force