I think most threads work in most machines. The reason I finally decided to try Aurifil is because I had heard it leaves almost no lint behind. This means less frequent need to clean the machine, and also it's better for my (beloved, getting old like me) machine.
Another benefit is that the 50wt I use is thinner than regular sewing thread. What I am noticing is that this allows my seams to press flatter with less "roll" uptake in the seam (meaning the "scant" in my scant 1/4" seam is less now; I am closer to a full 1/4" ). These differences are subtle and won't matter to some people, but it's a definite benefit in my eyes.
For quilting, I am liking the look of variegated Aurifil 50wt when used with a decorative stitch. For plain quilting stitches, I'm thinking the 40wt might be better.
I used to use Mettler silk finish exclusively, for years. The higher quality threads like Mettler are supposed to be made with longer staple cotton, meaning they shred less and are smoother (not fuzzy). I could tell the difference between Mettler and Coats & Clark; I would say there is at least this much difference again between Mettler and Aurifil. So, as you can see from my rambling on here, I'm a convert to Aurifil. :D
I think the question isn't whether certain threads will work or not; most all of them work in most all machines. It gets down to questions about refinement and what matters to you personally as a quilter. In the end, a wonderful quilt isn't dependent on thread brand choice.