A poll of 2,000 adults discovered natives of the South Wales city consume more coffee than anywhere else.