I think it depends on the situation - the Holy Spirit descended on Jesus as a dove at His baptism. Christ would have looked merely human to those around him during His Galilean ministry. The three men who appeared to Abraham at the tree of Mam are, to me, a hint of the forthcoming revelation of God as a Trinity - represented as three men.
God overshadowed Peter, James and John in the form of a cloud at the Transfiguration, with a voice speaking to them.
Christ said that at His return, He would come on the clouds of Heaven in great power and glory. That's another image.
Then we have Revelation 2:18 NIV
"To the angel of the church in Thyatira write: These are the words of the Son of God, whose eyes are like blazing fire and whose feet are like burnished bronze."
That's at variance with His merely human appearance to the Disciples, even after His resurrection.
I think the vision of God at our Judgment will be a mixture of awe and quite possibly fear for many, allied with self judgement, as we see ourselves as we really are.
The Beatifiic Vision will be something else again.
In other words I don't know what God's going to look like. What we have been told is that if we look upon his face in our normal human form, we will die. So He hides Himself and we cannot see Him.
Actually the whole spiritual universe is pretty good at hiding - the only time we see them is when they choose or are told to show themselves, and that's rare. In hundreds of years of turbulent Jewish history, Gabriel is recorded as appearing just three times - to Daniel in Babylon, the father of John the Baptist Zechariah, and the Virgin Mary.
Other than that he remained hidden and silent. So does God most of the time.