Notification settings are saved to your user account and are shared between all clients which support them (including desktop notifications).
Rules are applied in order; the first rule which matches defines the outcome for the message.
So: Per-word notifications are more important than per-room notifications which are more important than per-sender notifications.
For multiple rules of the same kind, the first one in the list that matches takes priority.