Massive Star Formation in Luminous Infrared Galaxies: Giant H II Regions and Their Relation to Super-Star Clusters