Rune Factory: Tides of Destiny takes players to a variety of islands as they try and figure out how to cure a mysterious curse . While the game does involve fighting, there is no gore. Little King's Story also has good reviews. It is a combination of a role-playing and simulation game, where players take on the role of a monarch in a small town. They must gather citizens together and assign them jobs, while trying to meet certain objectives . Like Rune Factory, there is fighting but no blood. A few other titles to look into include The Last Story, Arc Rise Fantasia, and Harvest Moon: Animal Parade.
While they are not role-playing games, the Just Dance series has great reviews among children and adults alike. The concept is simple; you have to dance along with the characters on the screen, which means that the game is very active instead of stationary. Another plus is that you only need the Wii remote to play, so no extra equipment is required, keeping the price down.