Got it half working thanks to this guy.
All we need to do is plug the controller into the OTG cable before you plug it into the tablet. Simple as that!
Now USB/BT Joystick Center detects the hardware, and all keypresses. However, no other apps seem to detect any keypresses (e.g. Mupen64Plus, XBMC 12.0 BETA 2 etc.)