It is not the purpose of the Trinity doctrine to "explain the role of each 'Person' of the Trinity" in... anything. The doctrine was formulated to counteract the heretical teaching of some that Christ Jesus was a creature, created by God, and thus, not God. There were, for example, followers of Arius who taught that only the Father is God in the fullest sense; the Son and the Spirit are ontologically inferior (which means that Arianism is also called 'Subordinationism'.) This book explains:
"[Arius] took a step beyond Origen, denying the essential unity of the
Son with the Father. Arianism taught that there was a time when the Son did not exist. It was chiefly this heresy that the early creeds targeted when they affirmed that the Son is consubstantial - that is, of the same essence (Greek, ousia) or substance (Latin, substantia) with the Father (and the Spirit). Thus, according to Arians, the Son is God's first creation, through whom he then created the world." Pilgrim Theology, p.178, Michael Horton, Zondervan 2011
Given that during the century before Arius, the Christian Church already believed in "Jesus Christ, true man and true God", the clash with what Arius taught centered on whether the Logos / Word / Son of God had been created by God the Father, or not. A mantra of Arius was, "There was when the Son was not". But here is the irony - Origen never tired of emphasizing that the Logos / Word is God's very Son and in no way created or begotten in time, yet Arius claimed Origen as the source of his subordinationism of the Son!
But, back to the question, now that I've explained what the purpose of formulating the Trinity doctrine was, the simple answer is this. Trinitarians who uphold the Bible as the foundation for their belief in Father, Son, and Holy Spirit all being involved in the creation of everything, have no need to explain the "role" of each in creation. The Bible does not give details further to Genesis chapter 1 and John's gospel chapter 1.
The Colossians and Romans verses cited by the OP do not explain their roles in creation, therefore, neither can we. We simply accept that all three were involved, in utter unity and oneness of purpose.