Are spaghetti straps comfortable all day?

They can be, with the right fit. Straps that are too tight dig in at the shoulder; straps too loose let the bodice slip. A well-tailored spaghetti strap dress should feel light, secure and almost invisible. If you can feel them at the end of the day, the straps need adjusting.