In the church I was brought up in they taught that Jesus’ death paid for everyone’s sins except for those who are really bad like murderers etc. and that the wrath of God was taken away from virtually everyone. What does the Bible say?

John 3:36
Whoever believes in the Son has eternal life; whoever does not obey the Son shall not see life, but the wrath of God remains on him.

Romans 2:8
but for those who are self-seeking and do not obey the truth, but obey unrighteousness, there will be wrath and fury.

Isn’t this unfair?

Romans 9:22-24
What if God, desiring to show his wrath and to make known his power, has endured with much patience vessels of wrath prepared for destruction, in order to make known the riches of his glory for vessels of mercy, which he has prepared beforehand for glory– even us whom he has called, not from the Jews only but also from the Gentiles?

Ephesians 2:3
among whom we all once lived in the passions of our flesh, carrying out the desires of the body and the mind, and were by nature children of wrath, like the rest of mankind.

If we don’t believe God is a God of wrath, it dilutes our thankfulness for the fact that He sent His Son to be a propitiation for us.

1 John 4:10
In this is love, not that we have loved God but that he loved us and sent his Son to be the propitiation for our sins.

Romans 5:9
Since, therefore, we have now been justified by his blood, much more shall we be saved by him from the wrath of God.

1 Thessalonians 5:9-10
For God has not destined us for wrath, but to obtain salvation through our Lord Jesus Christ, who died for us so that whether we are awake or asleep we might live with him.