Sounds similar to my experience with other systems (like Red Hat).
Amazing - you've just realised that IT systems don't always work.
Welcome to IT world !
"welcome to IT world" is just dismissive and needlessly aggravating. Just because systems can break doesn’t mean we should throw up our hands and accept the terrible state Debian package management is in. Debian-style package management has specific architectural issues, combined with maintainers writing poor package scripts, that make breakage seem far more common than it should be.
I asked you to be very specific. And you refused. You are criticizing "apt" for "specific architectural issues" but it is still very, very vague. Once again - be specific please. Can you? What exactly are the "specific architectural issues" ?
If you worked for a politician, you would look like hired by PR agency to throw a sh..t on someone else. I believe (and hope) you are not ?
I didn't refuse, I gave a very specific answer, namely that debians package manager can brick your system at any time because there are literally no safety mechanisms. That is the "specific architectural issues" I'm talking about. What more do you want? The code to prove it? Here it is: https://gist.github.com/rowanG077/27cd0a9417dd48593e63018783...
You are right: you didn't refuse, you are cheating (especially people who don't understand nuances)
You provided a content of a deb package that is intentionally malicious.
It is like a saying that car from specific car manufacturer is dangerous for people. When asked "why" your answer is: "Because you can suddenly turn the car and hit people waiting at a bus station".
BTW, I hope you already know that in i.e. Red Hat you don't need rpm package to brick your system. It's much, much easier.