While chatting with host Andy Cohen on Monday night, the 77-year-old bodybuilder-turned-actor revealed that the 1988 comedy Twins has earned him his biggest payout