I would create the automation with the Schedule Rule.
Set the Schedule for 10pm to 6am and set the action for the Camera to be turn on Notifications. at 6am, the notifications will be off. At 10pm the notifications will be turned on.
Then make sure you set the options you want for notifications in the camera settings