Hi all, for those who still don't get it to work properly I have written a tiny guide on how to get the Sparkfun USB Host shield to work with Leonardo (attached here) that might clarify some things, this setup worked out well for me
sparkfun-usb-host-shield-hack.pdf (1.23 MB)