Actually there was a sweet Japan only (but it has a translation patch available) NES RPG called Sweet Home. Made by Capcom, some say kind of a prequel of the Resident Evil series because of a lot of the elements they share, but it was still an RPG. Bit fucked up too, but still good fun.
