When looking at the financial alternatives, don't forget that there is also a financial cost in moving, to say nothing of the upheaval. It can be a stressful time.
If you've got a happy tenant, keep them in the place. If you move in, renovate, and move out, you may have a vacancy.