What is a good flexible way to send auto system emails to users?
I think the most easy and user friendly way for you is to use Rules module.

EXAMPLE:
Create new rule

Add action




Follow next steps to set your mail.