This is a very old bug.
ive had it too and fixed it with a 2007 mod.
https://www.moreawesomethanyou.com/smf/index.php?topic=9607.0
I have described the issue on another thread, but basically, it is caused by an error on the Tour Guide upon returning to hotel from a community lot, which makes him infinitely duplicate while loading him, so it never loads.
that 2007 mod fixes exacly that.
note that the mod wont remove the already duplicated copies of the guide in your lot files, so you might need a new neighborhood/save
