In many countries if a doctor believes you're too sick to work you have a right to take leave until you recover, without risking your job and without expending limited "sick days". In those circumstances the doctor will of course prescribe something for your pain, but as a patient you have no incentive to insist the painkiller is strong enough to allow you to continue working.