I use the shortest needles, a #11, but not the thinnest one. Some brands offer a very thin #12 and this is not sturdy enough for my hands.
A few years ago I learned that the right needle's size also depends on the method you use. On a fair I had the opportunity to watch a lady from Australia demonstrating hand quilting and she used very long and thin appliqué needles! The result was breathtaking....