Optical spectroscopy of emergent excitonic states in atomically thin heterotrilayer and bilayer semiconductors