One option would be to set up and use Modes. Modes are nice because you can use them globally. So you would just have to pick XYZ brightness for Night Mode. And you could do this simple selection for nearly every bulb or app or whatever so you don't have to keep selecting times of day. Modes can also do more, like triggering home and away actions, so you may want to look at them. They get really helpful on larger or more complex installations.
Restrictions also are a good choice if you want to just restrict one device, or the times don't align with the Modes you set up. You could restrict the bulb to turn on between 8AM and 10 AM at one brightness, and do something else (or even nothing) at other times. With restrictions you will probably need multiple instances of similar Simple Automation rules to do what you are asking, but so what if you need 2, 3, or even 10 small and easy rules to make it work like you want. Rules are free, and simpler is better, so keep things simple if possible.
For the Rule Machine question, you could do everything in one rule. But RM is a much harder to learn advanced tool that I do not suggest people start out with. I would use Motion Lighting, Simple Automations, and the other easy things first until you outgrow them, or at the very least get used to how the hub works.