This is great news! A close friend tried to give his parents, wife, doctor and me (each individually) the legal ability to do this if he went off the rails.
When he went off the rails, the authorities absolutely refused to do anything, even after he started talking about shooting up a local synagogue.
We eventually got him care, but only after he was fired, divorced, homeless and went from $100,000s in savings to $100,000s in debt. (The spending was on non-medical things. He had health insurance at the beginning of this, but eventually stopped paying for it).
The healthcare workers said this was pretty much the best case outcome because of current law.