Ok, so after getting desperate I did a completely fresh image install/upgrade to Retropie 3.0, configured the controller and sure enough now it works! The second port even functions as player 2 without any set up. No idea what changed but that seemed to fix it!