Photophysics of Single to Multiple Excitons in Carbon Nanotubes