As a site visitor Cloudflare's certificate is the certificate you want, because that's the certificate the site owner has chosen to give you.
Cloudflare is not in the middle, it is is part of the server. We just have to adjust the notion that a server, from the protocol POV, is not a single machine with a single process httpd daemon anymore.
As a site owner true. As a site visitor it gets a little more complicated and murky.