I get 5 fps and texture errors while playing Super Mario Sunshine on Dolphin :smith:
I had SMS playing great on an old build of Dolphin with some settings tweaks, but I posted it in the GMF somewhere and I forget where
If I find it I'll copy it here
EDIT: Found my post - it uses a really old build so find it if you want, or try the same settings on the current build:
Using Dolphin SVN 6700 x64 version
NO I'M WRONG USE 6599 x64!!!!!
NTSC ISO of Super Mario Sunshine
Game config:

Basically make sure nothing is checked/unchecked and have no projection hacks enabled
Dolphin config general tab:
Dolphin config display tab:

Notice panic handlers off
D3D9 plugin config general:

EFB scale x2 was the only one that didn't make the goop slide away
D3D9 plugin config advanced:

All guides say real XFB but no, it made it look like shit for me
Also turn off audio throttle
With those settings I got 30+ FPS and no visual glitches, except the level with the giant shadow stingray - there was a certain tweak you needed to make that level playable at all but I forget it