I would just suggest you so the same search with "wrath". It occurs 199 times, sometimes referring to the wrath of God and sometimes to man.
@Alan Dale Gross is right in that statement. There are times in scripture where the scenario is that God's wrath has broken out on the people of Israel and Moses tells Aaron to go immediately out to atone and intercede for the people. To find those instances you can plug in "wrath" because the word "appease" wasn't used but the concept Alan was suggesting is. So is "atone".
Also you will notice that the use of "wrath" means something like "anger to the point of being acted upon". That's just my own definition so take it for what it's worth. That is important because in that sense yes, wrath can build up so to speak, be a mounting emotion so to speak, yet be withheld without being actually manifested. So a saint, before he was saved may indeed have been accumulating "wrath" (potentially) but if in due time he repents, based on Christ's propitiating work, this wrath will never be executed upon him. And God being a judge and this being an important enough concept that it is said that God is just and a justifier (so indeed that matters), it is proper to say God loved us even while we were in our sins and in fact we all were timewise when Christ died for us.
Lastly, in the search of the word "wrath" in scripture, it is often used referring to human wrath. And it is explained that usually, our wrath is sinful for several reasons. One, it can occur for unjust reason in us. Two, it can result in doing things we are forbidden to engage in. Three, as creatures, we have fewer rights, have been forgiven much ourselves, and are not in a real position to administer judgement and act on our wrath.
But God is in such a position, and it is part of his nature and how he reacts to sin. I would suggest that if you look up all instances of "wrath" in scripture and read in context, without aid of commentaries, you will begin to understand the role of wrath in penal substitution. If you don't think it fits at that point then nothing else need be said.