Should I give this client a song & dance, or the truth?

Yes, art is a business and you behaved in a very unbusinesslike manner. I mean you were already there. The least you could have done is walked in and had a coffee with the guy.