Well there IS thread made specifically for hand-quilting, it's coated or glazed or something. I don't do much hand quilting. If I remember right, it's fairly thick and heavy. I do know you don't want to use it in your machine.
I agree, a 40# thread will show up nicely. I like Superior's King Tut.