Oh, he is the consummate songwriter's songwriter.
Some folks aren't that into his voice and for you, I recommend Harry Nilsson's album:
Nilsson Sings Newman
Exactly what it sounds like; an entire album of Randy Newman songs, sung by the marvelous Harry Nilsson. They were birds of a feather, really.