Short answer
Yes, if you give it that action, although it isn’t always a good idea. An upgrade can be undone, and some companies automate it. A downgrade or a cancellation moves money and doesn’t undo itself, so the sensible setup is for the agent to prepare it and a person to confirm it.
In detail
Where to draw the line
At whether it can be undone, more than at how important it looks. An upgrade can be reversed; canceling, deleting or refunding can’t. With what can’t be reversed, if the agent gets it wrong nobody finds out until the customer complains, and by then the money has already moved.
What it handles alone, with no risk
Explaining what each plan includes with that account’s usage in front of it, saying how many seats are left or warning that a limit is close. That’s most plan conversations, and none of them change anything in your systems.
The sales opportunity
Some support questions are upgrade requests nobody has spotted, like "can I do this?" when the answer is in a higher plan. Spotting them and passing them to whoever owns the account pays off more than automating the plan change.