He made suburban characters shine in Fountains of Wayne songs and brought pop-rock perfection to the Tom Hanks film “That Thing