different people find different needles work best for them- i use milners or straw needles (i like long needles) or a sharp= traditional hand quilters who have been at it a long time tend to use betweens (which are very very short)
choose a size appropriate for the thread you are using- and the needle that is comfortable for you to work with. i know a wonderful hand quilter who uses applique needles- it's all a personal choice- i wouldn't buy a package of 50 of one needle just to find out you simply can not work with that needle.
people do comment on how tiny my stitches are- and i always use long needles- they are what works for me