Soft forks tighten the rule set of what transactions are valid. Additional opcodes allow existing owners of coins to put additional constraints on how those coins are spent.
Many covenant-enabling opcodes are nothing more than "new", more specific sighashes[^sigh]. Other opcodes allow access to information about a spending transaction.
None of this is conceptually objectionable. People should be able to put constraints on their property. But first we must do no harm.
The concrete issues, when gauging additional script functionality, are: