Other modding/hacking scenes?

most of the main sites have been shown, i love smwcentral even tho its not as easy to navigate as this site. It has loads of super mario 64 hacks as well as world snes stuff, some great programs can be found in particular SM64 Level Importer 1.9.4S by Skelux that allows for importing of google sketchup 3d models, skyboxes, water, scaling for maps and various star settings for bosses. Toads tool by vl tone that allows for object setting, stars enemies coins and various.

I like Zelda64.net it has some nice hacks including:
project first quest: http://forums.zelda64.net/topic/11194414/9/#new
ocarina of time revisited: http://forums.zelda64.net/topic/11565325/9/#new
ZEY: http://forums.zelda64.net/topic/11388182/1/
Project beta triforce: http://forums.zelda64.net/forum/4209182/
to name a few decent hacks of the game, it also has a lot of tutorials for programs such as
hylian tool box (level importer/model importer with collision settings for lava, hookshotable, slippery etc and object adder)
sharpocarina similar to above but a different style more easy to use program less in depth tho such as no character models
scene navi level editor for vanila and a few other cool programs.

http://www.pokecommunity.com/forumdisplay.php?f=156 for all your pokemon hacking needs.

http://forums.qhimm.com/index.php some good final fantasy ps1 era mods and hacks here

http://www.moddb.com/games/doom/mods lots of great doom 1,2,3 wads and mods

http://www.emutalk.net/ great place full of lovely hires textures for old games

http://yanfly.moe/ guy makes amazing plugins for rpgmaker mv

there's some of my frequents for ya