I think take his enthusasm slowly DB, to protect yourself.

Set some boundaries, and state them in a calm and friendly way.

You decide when he comes, how long he stays.

How does that sound?

positive reinforcement, but baby steps.