When I was a middle manager, I never had a problem implementing decisions I didn't believe in per se. Reasonable people can disagree on strategy and tactics without having to sell their souls.
On the other hand, I had all kinds of problems working for upper management I didn't believe in. When I didn't trust the folks above me, it was very difficult for me to implement even fairly benign changes.