The money in your bank account exists only as a liability of the bank. It is just a number in the bank's database. And each bank has their own database. So transferring money from bank A to bank B means that bank B must agree to take on the liability, in exchange for something else.
Most of the time, the illusion of a global ledger is maintained, but it can break down when the system is under stress (e.g. financial crisis of 2008). Introducing a CBDC would fix this, and would make money work the way we already think it works.
If you worry about the stability of interbank lending and solvency of banks, you resolve that with legal requirements around lending and reserves, not introducing a new optional form of m0
Scenario 5 in this whitepaper hints that the ECB is considering a CBDC for this reason nonetheless. (Some other reasons are also given in the other scenarios.) They also talk about how a CBDC would be competition for commercial bank money, so the consequences indeed do need to be carefully considered.
https://www.ecb.europa.eu/pub/pdf/other/Report_on_a_digital_...
Yes, this is how money works and is created today through fractional reserve lending. This has the tremendous advantage of being able to finance economic growth on credit, with a corresponding inflation risk that needs to be managed. That's a feature not a bug.
And "audit" not as in "spend millions on an auditing firm to do it for you", but audit as in "independently verify it yourself on your own computer".
Having a cryptographically verified history of everything my government is spending on would be cool, but due to the nature of the distributed ledger it would require private citizens be put under the same microscope. At least with the alternative of one central bank controlling one central database, there's some degree of restriction to personal information (I'd imagine the bank wouldn't let any average Joe request ledger data on their neighbor just for fun, but public interests would be fair game).
Simply knowing how many reserves the bank holds gives you no indication whatsoever of its solvency.
People are silent about it because Tether pumps their bags, sadly.
There are no smart contracts in those systems though, and I guess it will take a long time to implement that - if ever. And without smart contracts you can have no tokens, DeFi and whatnot.
Like you say, when the central bank is managing it you have already done away with "trustless" since the central bank itself is the trusted party. At that point, why bother with blockchains and the like. Just have the central bank manage a big database and be done with it.