Memories of Fear: A fan translation group that focuses on rpg maker games. As you can tell from their name, most of their games are horror. Unfortunately, they disbanded in 2021.
Romhacking.net: The number one romhacking site on the internet. This is where I used to get all my romhacks.
RetroGameTalk: Where I get all my romhacks now. All of them are pre-patched, so if you know nothing about patching or applying the patch is more complicated than usual, you don't have to worry about anything! You have to sign up in order to see the repository though.
Anime Game Translation Team: Another fan translation group that mainly focuses on handheld lincesed games. I've played quite a few of the games they've translated.