I have used the three mentioned.
I like 505 because it works so well and doesn't seem to have the petroleum by products. A little goes a long way and it stays for weeks or maybe months!
I am now trying Sullivans. I am not happy with the petroleum by products. I make sure to spray outside. They suggest you wait a few minutes to let the product to get tacky. I used it a lot sooner without a problem. It also goes a long way!
Neither of these products caused any problem with needles gumming up.
The other product, June Taylors, seems to be liked by some here on the board. I personally tried it and didn't like it at all. Maybe I got a bad can, but I have little to say in it's favor.
Overall I think I like 505 the most. JMHO