Leonard Nimoy Turned Down A Power Position For Star Trek: The Next Generation
Leonard Nimoy directed three more films after that, with the last one (Holy Matrimony) coming out in 1994, the same year that Star Trek: The Next Generation ended after seven seasons.
So, it seems clear the talented actor wanted to branch out and explore his growing skills as a director. If he had been an executive producer for Star Trek: The Next Generation, those first two seasons might have been better.
Then again, if he had clashed with franchise creator Gene Roddenberry (as so many writers and producers did in the early days of the show), he might have stopped appearing in Star Trek shows and films altogether.