It seems that Bioshock has support for Xbox360 controller, but not for any other controller
I've been working on this profile for my Logitech Cordless Rumblepad 2, and at this moment i'm pretty happy with it. It has some things you need to get used to, like that you can cycle through weapons or plasmids only in one way, but since it is very fast, it is not a real problem.
I have to say that i'm on the beginning of the game, so i'm not able yet to test the thing you do with little sisters (i do not want to spoil anything or the Search Again plasmid, but i think it should work ok.
I have reduced the speed of the right stick to 40%. It feel much more precise and makes the hacking much more easy.
Anyway, i'd love to have some feedback
All the best