I started out with pins and hated them.
Switched to spray and love it.
I've never had a problem with it not lasting and I never quilt quickly; they are done over time. Never a problem with it giving out.
Yes, don't spray heavily. And if you can do it outside so much the better.
I now have a vent in my quilting room but haven't gotten to the point of spraying in there yet.