Mine shows usage when I am sleeping.
But you might be on to something, recently my iMac starts staying awake all night.
I wonder if your Mac might be waking for iCloud or incoming iMessages and then staying awake due to repeated server connection attempts. Perhaps the same thing is happening with iOS devices.
I noticed my iPhone shows increased usage overnight while I'm sleeping as well, but it's limited usage compared to the excessive usage I notice at other times. While I'm sleeping, usage increases "only" about 30-40min over eight hours. Not bad when you compare it to the other periods where it can increase 30-40min in under an hour. It's these periods I'm calling excessive, and I can generally correlate some other device and iCloud usage to coincide with it when it occurs. On my Mac, I use Safari, edit some Notes, maybe send a handful of iMessages. All using iCloud syncing.