I don't really subscribe to Machiavellian morals, so it would have to be loved even if I lost the title/role... At least the plebs probably wouldn't kill me in my way out of office.
Discussion
That's a good point, being loved may be a safer bet for a peaceful retirement.
Being feared could mean you have more power for longer.
I don't care for power or doing the kids of things that one needs to do to keep it.