www.Romhacking.net is an excellent site that tracks and hosts patches for both romhacks and fan translations, as well providing tools and a (usually) helpful forum to help you with your own romhacking adventures.

www.tcrf.net is a site dedicated to content cut or inaccessible in video games, and, while it won't help with playing said games, reading about this cut content is usually entertaining in its own right. Articles also tend to track differences between US and Japanese releases, though this varies from page to page.