In general just assume any Mario64 hack won't work on hardware or outside very particular emulators unless they otherwise noted. For some propaganda from their side, read this
. Mario64 hacks created with TT64 (outside 1-2 that fixed this problem) read from unaligned addresses so the more accurate your emulator the less likely it will be to run these. Recently-ish they've been using hacked emulators quadrupling the amount of RDRAM in the system; obviously these won't work outside a select few emulators.
Basically, RetroArch is a fork of Mupen64plus. Not quite repackaged, but the support is fairly similar. You still have support of whatever its plugins can manage, so chances are decent for some of the texture pack stuff.