First of all, these were all offensive attacks, meaning that it is normal to lose even 3 times more than the defenders.
Second of all, when you have a nation ravage your country, murder, torture, and rape your people, nothing will stop you to kill every last one of them. I know it is difficult to put yourself in the shoes of the Soviet Union at the time, but that is one of the reasons why.
I do agree with you that in some cases a lot more soldiers were lost and there were possibilities to save, rather than lose. But you need to understand that in the heat of battle decisions need to be made quickly and in some cases, the wrong decisions will be made.
Another issue is that generals didn't have constant communication with the front line so decisions had to be made by sergeants and lieutenants on the field.