I'm glad that you brought up the Trinity, because not only is it something about which we can all agree, I have come to believe that pretty much across the board, we've not paid nearly enough attention to the workings of the Holy Spirit in the world. For example, have you ever considered the possibility that many, if not all, of the schisms across the centuries from Catholic/Orthodox to the Reformation to the splintering of the Protestant movement were/are the workings of the Holy Spirit? I'm not raising that possibility as fact, simply a consideration, as I wonder if Christianity would have spread around the world nearly so fast without the various ecclesial break-ups which caused one faction or the other to venture farther out into the "frontier".
Something to think about, at the least. Perhaps we needed to be torn asunder before the day can come when we are all sewn back together again... I suspect that when that final day arrives the Church of Jesus Christ will have no other name than that.
Honestly, I think these splinterngs are not of the Holy Spirit, for at the last supper Jesus prayed that we may all be one as He and the Father are one.
Can God bring incredible good, even out of evil? Certainly. The conclusion you draw would be, in my eyes, God drawing good out of evil, not the workings of the Holy Spirit.
But here we enter that old debate of God's Active Will versus God's permissive Will...Does God will bad things or just permit them so that He may draw good from them? Jesus answered this question when they asked Him who sinned, that a man he healed had his deformity. Jesus answered that it was not due to sin but only so that they could see the Glory of God.
Good thought provoking comments. Thanks.