There is a setting specifically for case comment notification named "Notify Case Owner of New Case Comments" within the Support Settings. Notification will be sent to the email address configured for the case owner (whether the owner is a user or a queue).
You should be able to configure a workflow rule with corresponding email alerts for the situation in which related tables are updated.
You should be able to configure a workflow rule with corresponding email alerts for the situation in which related tables are updated.