A bunch of the morons out there who turn off wifi out in public because they read some random NYPost article about it "tracking" you, would then be bitching to Apple and/or their cell carriers about why their performance is so bad at home when it doesn't auto-join wifi overnight.
I would agree with you that it should operate like a dumb toggle if they didn't have the notification saying that it would auto re-enable again.