The games you have working are old games.
The games that don't work are newer games.
NSMBW is a special case, look for a guide on that by Davepm.
Silent Hill needs no special consideration but will require #002 error fixing.
Your loader may need updating to one that supports #002 error fix, check out Neogamma, I think there's a download in the Homebrew Download section of the forum.