I take a long time hand quilting, a year or more, and have no problems with the basting spray holding. I have used Sullivan's on more than 7 quilts now, but I'm going to try 505 on the current one I'm piecing now.
I used to use the "gun" to tack the quilt, but I kept poking my hand, and, Oh, I don't know, I just didn't like it. It took too long and hurt my back. This only takes minutes.