I had this same issue a couple days ago!!!

I tried resetting the sims and everything, I ended up saving and restarting the game. He appeared and then at the same time he disappeared again!

So I checked my Mods folder, reinstallled awesomemod and the configuration tool and restarted the game again and everything was fine.

Unrelated::: I reinstalled the game and awesomemod because I was having to many issues with the game crashing at the load screen and I deleted my old save games and started a new game. Havent had any problems yet and will prob wait until they update awesomemod before I install today's patch.

So good luck.