I've never been confused by the doctrine of the Trinity because I don't believe in it, but upon reading about it I did find it to be confusing that others would believe in it since it is not in the Bible or any revealed scripture that I am aware of. The part that is extremely confusing is when it is taught that the Father and the Son are the same being and yet separate and distinct persons. Apparently this concept was devised in the post apostolic era a good time after the apostles and Christ were no longer leading the church.
At Mass Catholics say the Nicean Creed every time. Here is the official explaination:
Q: In the Niceno-Constantinopolitan Creed, why has "one in being with the Father" been changed to "consubstantial with the Father?" A: The new translation is...
www.usccb.org
"The bishops at the Council of Nicea (AD 325), in order to ensure that Jesus was professed as the eternal Son of God, equal to the Father, stated that he is "the Son of God, begotten from the Father, the only-begotten, that is from the substance of the Father, God from God, light from light, true God from true God, begotten not made, the same substance (
homoousion) with the Father..." The Creed of the Council of Constantinople (381), which is professed at all Sunday Masses and Solemnities within the Catholic Church, similarly stated: "We believe in one Lord Jesus Christ, the only Son of God, eternally begotten of the Father, God from God, Light from Light, true God from true God, begotten, not made, of the same substance (
homoousion) with the Father."
I can put a slight scientific spin on it, the Big Bang was created from God's energy, this dimension is under the Son's authority. There may be other universes under different Sons called the multiverse. "No one comes to the Father except thru Me".
The Holy Ghost is apparently the connector between Jesus and the Father, IMHO the Holy Ghost is "female", making the Holy Family in the image of humans, or vice-versa.