It is detected perfectly fine on my Mac.
It is self-powered an I hear it spin when I plug it in the Pi.
Sometimes when I boot it shows when I run
lsusb, sometimes it doesn't. If I unplug it and try plugging it in a different port, it is eventually detected after a few tries. (And then I can mount it with ntfs-3g and it works fine, although I haven't managed auto-mounting for the few times it was detected at boot)
I think it cannot be a driver problem because it is detected sometimes. Can't be power either since it has its own PSU. I'm really at a loss. Not a defective USB port either, I've managed to get it mounted at least once from each port.