Both acids can cause mild stinging during application.
Salicylic acid is generally painless but may cause discomfort if overused (Source).
Glycolic acid might feel more intense initially, but most folks find it tolerable.
Just remember, no pain, no gain!