Let us suppose I do not want notification to be sent when there were no actual SCM changes (for example, build was triggered by upstream one and simply succeeded). In my understanding it is not possible to achieve with currently available options.

With new "Success with changes" I would simply disable existing "Success" trigger and enable "Success with changes".