Simple Automation, basic rule, and most stock apps have a restriction section where you can disable based on mode. Rule Machine does not but you can use a required expression or if statement. Many community apps also use it as well.
I personally keep things simple with modes that match a typical alarm system: away, day, night. I have seen others have many more modes than that. I do utilize virtual switches to augment things with mode too as again with the stock app restrictions they can also be restricted by the state of a switch. So for example Away mode turns off various lights because I am not home but typically I will return several hours later. But if I am gone for an extended vacation I flip a vacation virtual switch that will disable a few simple automation rules from firing that turn on lights I would only need on if home.
You may get some good info from this older post as this question has been asked a few times in my 5 years on this community:
