Auto, Wi-Fi only.
Sometimes I'll manually update games as can't use them otherwise but apart from that always auto.
Do apps suddenly start updating while you're busy doing something else and slow everything down?
Not really. I think I might have another setting that I am not sure about as they tend to only update when I'm plugged into a charger, which is generally overnight.