You're way overthinking things.
I never had a backup strategy. I usually have my most important files and photos uploaded manually in the iCloud and I also have an external SSD where I store my most important files.
That is the definition of a backup strategy.
Everyone's work needs and commensurate backup requirements are different. You have to decide which works best for you, but if you have lost personal photos a few times it suggests you need to review that strategy.
I have also purchased CCC but I admit I don't know how to use it.
I believe they have robust support and documentation.
Also it is my "OCD", I am trying to use as much as possible the macOS built-in tools and try not to over-bloat my system so I am installing only the minimum tools needed.
Then use TM. It's already installed. There are no additional tools to install.
So, I want to understand, is CCC bringing any benefits over the Time Machine? I don't want to have automatic backups, all I want is one time a week or once several days to backup my system on an external disk, manually. This backup I think is enough for me. I don't want to have snapshots to return in time. What is the difference between CCC and Time Machine? Is it any better? I already purchased CCC 7 (the price is not so high). What is the best strategy for backup? What is this 3 2 1 strategy?
People grow fond of their idioms and their trite little rules of thumb, but when important details become lost in them then they are performing a disservice. If you ask a "3 2 1 strategy" means, you will get different answers, leading to confusion. So what benefit does that cutesy expression convey? You decide.
The bottom line is use what works. For me, a robust backup strategy means that all backups are never in the same geographical location. Simple math means at least three separate backup devices will be required, so that one of those backups are never in the same place at the same time as the other two. Since a backup disk needs to be connected to the source Mac when it backs up, a single catastrophic event — ranging from a lightning strike to a flood to simple user error — can simultaneously destroy two. One copy of your data remains — the one stored separately. Is that enough? You decide. Use what works for you.
Use Time Machine on your Mac to back up to multiple disks - Apple Support
I need advice from people doing this.
I have been using TM since its inception and have had zero failures to back up or restore. Before then I used a different commercial product that worked somewhat like it, but TM made it obsolete. I had also used CCC for some time in the past but determined that it did not offer any advantages. There is nothing wrong with that product though. Use it if you want. It's fine. But like any backup strategy you have to use it.
My internal MacBook has a 4 TB drive and I have two external SSDs of 4 TB each.
That won't work. Because...
Time Machine requires double the internal storage
TM ideally requires at least 2x the storage capacity of the source disk. You might be able to get away with less depending on the amount of internal storage that is actually used, but determining the latter has become difficult due to the way macOS manages that internal storage. It's not obvious, and it varies widely. Use 4 GB or larger external hard disk drives and it won't be a concern.
I don't want to have automatic backups, all I want is one time a week or once several days to backup my system on an external disk, manually.
Then don't connect your backup disks but one time a week or once several days. Time Machine will work anyway. Backups will be written to disk whenever they are connected. If you forget to connect them, TM will complain after ten days have elapsed. Backing up to a NAS means you won't have to remember to connect anything, but that's beyond the scope of your question. For that I use Time Capsule but Apple is being quite vocal about the fact they will no longer be supported in the near future. Since I have used a non-Apple NAS device in the past and concluded it was not reliable, I am developing another solution of my own design in anticipation of Time Capsule going away.
Some people use both CCC and TM. CCC is a fine product that I used in the past but determined that it did not offer any significant advantages over TM.
Part 2 of this longwinded reply follows below.