I've been using Coats & Clarks all purpose Dual Duty for years. Have two couch quilts that are over 15 years old and are in constant use and they seem to be just fine.
The hand quilting thread is usually heavier than the machine thread.
Threads come in different weights/thicknesses - from thread that almost seems to be a lightweight cord to very very thin.