I installed the mod eligible for use in HOF games and I rigged it so that it loads automatically. After I completed my first game with the mod installed, I noticed that I only the one game listed in my (personal) Hall of Fame. Is there a separate hall for each mod?

Yes. I read somethings about that in the forums.
Your CIV HOF is displayed according to the MODS played!