A home with six automations that always work is better than a home with sixty that mostly do. These are the ones worth building first, in the order worth building them.
Build the routines you already have: leaving, arriving, going to bed, occupancy lighting and the safety alerts that matter. Six automations that always work beat sixty that mostly do. Give every automation a manual override a guest could find, and if one fires wrongly twice, fix it or delete it.
The short version
The single highest-value automation in any home. When the last person leaves, the house closes down: aircon off, lights off, water heater off, non-essential plugs off, security armed.
The hard part is knowing everyone has gone. Phone location alone is unreliable - it lags, and it drains batteries. The pattern that works is a combination: phone presence, plus the main door having opened, plus no motion or presence detected for a few minutes. Combine three weak signals and you get one strong one.
Give it a manual override. There is always the day someone is working from home in silence.
The mirror image, and the one that makes the house feel different. As you approach, the aircon starts in the room you will actually use, the entry lights come up at a level appropriate to the hour, and the gate or door is ready.
Restraint matters here. Every light in the house coming on at full brightness at 11pm is a novelty for one week and an annoyance thereafter. Time of day should change what happens.
One action, whether it is a button by the bed, a voice command or a schedule: lights out across the whole house, curtains closed, aircon to its overnight setpoint, doors checked and reported, and the night lighting mode armed so a 3am trip to the bathroom gets five percent floor light rather than the ceiling at full.
This is the automation clients mention most often, because it removes the walk around the house checking things.
Bathrooms, the yard, the store room, the corridor, the stairs. Rooms you pass through with your hands full, and rooms where the light gets left on.
Not the living room. A room where people sit still is where naive motion lighting fails - the light goes out while you are reading, and now the smart home is a problem to be solved. If you want automatic lighting in a living space, use a presence sensor that detects a stationary person, and always leave the wall switch authoritative.

In Singapore this is where the money is. Three rules cover most of it:
Nothing here is clever. It is just the discipline nobody applies manually.
Most notifications are noise. These are not:
Anything that does not need action does not need a notification. If an alert gets ignored twice, delete it.
A door contact is certain. Phone location is a guess. Build on the certain one and use the guess as a supporting condition.
Time of day and someone-is-home cover most edge cases.
The wall switch, a button, a dashboard toggle. An automation you cannot interrupt is a fault.
Most annoying automations are correct but too fast.
Real households are messier than the plan. Adjust once, then leave it alone.
Once these run reliably for a month, the interesting layer becomes worth building: per-room climate profiles, laundry and appliance chains, guest and helper modes, irrigation on weather forecasts, energy shifting, adaptive lighting, and the household-specific ones that only make sense in your home. That is what the design session is for.
A complimentary design session covers all of this against your own floor plan, with a live Home Assistant system in front of you.