I would think if you wanted this to be a database for games, the priority would be preserving data as is and not based it on scrapability. I do understand the need to be able to scrap titles but couldn't this be done with additional fields? Couldn't the No-Intro data be Incorporated into the game data base? Same with EmuMovies, have a way to save there titles into the database for better matching.
As for Super Mario Advance 3, I find it hard to believe that they really wanted it called "Super Mario Advance 3: Yoshi's Island". All indications point to them wanting "Yoshi's Island" as the main title, and lesser importance to the series name "Super Mario Advance 3", You can check out the images from the database and on MobyGames.