Ok - fixed. Not entirely sure what's going on, but I ended up having to drop the tables again, enable the extension (which "worked", but didn't create the tables), then recreate the tables manually in this order
Polls -> Poll_Options -> Poll_Votes
Works now, but very odd behaviour.