Nowhere does it say that Jesus, at the Rapture, only comes back to the clouds
It doesn’t say that anywhere with regard to the rapture. It clearly says that he will be seen in the clouds returning with regard to the Second Coming of Christ. In Matthew 24:30 He will be seen in the clouds as He returns. This is a return after the Tribulation as is stated below. Revelation 1:7 further confirms this with additional words that every eye will see Him. At the rapture people are suddenly caught up in the clouds to meet the Lord in the air.
29 Immediately after the tribulation of those days the sun shall be darkened, and the moon shall not give her light, and the stars shall fall from heaven and the powers of the heavens shall be shaken. 30 And then the sign of the Son of man shall appear in heaven, and then all the tribes of the earth shall mourn. They shall see the Son of Man coming in the clouds of heaven with power and great glory. 31 And He will sen His angels with a great sound of the trumpet, and they shall gather his elect from the four winds, from one end of heaven to the other. —Matthew 24:29-31
Behold, He is coming with the clouds, and every eye will see Him, even those who pierced Him; and all the tribes of the earth will mourn over Him. Even so, Amen. —Revelation 1:7
Then in 1 Thessalonians 4:15-17 it says that those who are alive and remain will meet Him in the clouds. This does not preclude Him from being here on the earth for a little bit and then meeting Him in the clouds before He leaves.
15 For this we tell you by the Word of the Lord, that we who are alive and remain until the coming of the Lord will not go ahead of those that are asleep. 16 For the Lord Himself will come down from heaven with a shout of command and the voice of an archangel and with the trumpet of God, and the dead in Christ will rise first. 17 Then we who are alive and remain will be caught up together with them in the clouds to meet the Lord in the air. And so we shall always be with the Lord. —1 Thessalonians 4:15-17
With the proper understanding of just the timing of how we meet the Lord, other scriptures should open up to you in order to paint a better picture of when in the book of Revelation the Lord actually appears at the event of the rapture.