Qhimm and its Forum is one such place. It focuses mainly on modding FF7 (a bit of FF8 and FF9) and it has quite a nice community.