Simple email notification feature at the table level, where an email can be sent out on insert/update/delete of a table record with the details of the record that was changed, and maybe a URL that opens dbfront and takes the user to the table record in the email so they can review it.
I was thinking that the email would only be sent out under specific conditions (i.e. field A = x and field B = y and db command = insert/modify). I agree that some kind of logging at the database level seems more appropriate for audit functionality, but one important use case would be to notify the user of a certain kind of log entry. For example where a process result gets logged in a SQL table, the user only wants to know if the Status = Failed for that day.
For the scenario you describe I would recommend that you send out those notifications via your database server.
The reasons are:
You can setup your database server to mail as follows:
NOTE: Another feature request exists for emailing Action Button results. Action Button Email