The host is credited with reinventing late night US TV but also courted controversy – so what’s next?