I don't do much handquilting. I use YLI, or one of Superior Threads heavier weight when I do.
Sometimes when I'm just quilting to hold the layers together I use Bottom Line (also a Superior Thread, very thin - 60wt)
You could certainly use Aurifil to handquilt, if you like how it looks.