Sullivans, June Taylor, & 505 are all very effective. For people with breathing problems the 505 might be a better choice, but all have fumes to contend with, so proper ventilation is a must (even if it is an open window or large room). There is no need to over do it on the spray; I have found a finer mist works better than major spraying, which will also reduce the fumes.
As with any adhesive, if you use too much you will eventually have to deal with stuff on your needle. The great thing about the quilt sprays is they are water soluable and if this is a problem, you can usually wipe your needles off and keep sewing.
There are many spray adhesives on the market, but I can not comment on them being as I have never used them on quilts. (I am uncertain of their chemical composition and solubility, so I am not taking any chances when I know the quilts I make will most likely be against someone's skin.)