When choosing a career and you have only two options is it best to do something that you are good at or enjoy?

For example if it is your lifelong ambition to do job X, but you are not particularly good at it and unskilled is it best to go for that career or do something that you are good at but is mundane and something you don’t enjoy.

Also would you still take your decision even if the alternative pays more, or would you decide to choose your job based on the amount of pay as well?