The reason for your character to stay doesnt have to be something they agree with. It can be someone else’s reason.
And ‘the quest to fuck off and do something else’ can be fun too. You seem to be working with a very authoritarian concept of game. Those can work sometimes, but are very limiting.
less friction
Not always desirable.
Our group has done this. Shot our paladin at a dragon to try to wrestle the wretched wyrm to the ground.
The wrestling part was not very effective, but we did manage to fell the beast, so we had that going for us.