Im a cat lover , have 2 so I hope you find them soon. Cats are good at finding their way home so chances are you'll see them about soon.
Yeah I suppose you should give the guy a decent amount of time to see if this drinking and leaving the door open all night is his normal behaviour . It doesnt sound good to me though and remember its your house and he needs to respect that and your cats too!!
I hope it isnt long before you find them