The singer also reflected on his “mental breakdown” and covered Creedence Clearwater Revival during his feel-good set