I'd temper any expectations of seeing Steam Workshop support, much less Emoticons, Cards, or Achievements until further announcements are made. After the Playsim release it's safer to assume this will be a barebones, game only release - it's possible he learned a lesson, but right now there's no way to know that for certain.
I'll get beyond hyped if he actually does HSiFS the support it deserves but until then I'd reccomend anyone getting their hopes up - we'll know for certain soon enough, after-all.
No idea about ACoF since TasoFro will probably be handling that and they're, frankly speaking, a wild card, to the point where...I, uh, have to wonder if we might wind up with a situation where HSiFS makes it way over here but ACoF does not and is relegated to Japan-steam only.