Not only do they control your DNS they also control all traffic going to your site, also the connection between you and them is not encrypted.
I figured this would be a tutorial for letsencrypt. Cloudflare certainly is an option but it's not one I would recommend for -most- people unless I know why they're opting for SSL. If it's static content then sure- but I don't support cloudflare for dynamic content. I'm responsible for things like passwords and I can't keep that responsibility if I actually choose to MITM my own site with an external company.
Trust doesn't enter into it. I don't trust myself with your password so why would I trust anyone else?