I'm sympathetic to this idea but Daniel's prophecy here is very hard
Is it hard, or too literal?
"Know therefore and understand, that from the going forth of the commandment to restore and to build Jerusalem unto the Messiah the Prince shall be seven weeks, and threescore and two weeks."
Who is this Messiah the Prince?
God confirms the Covenant while on earth. It is not confirmed remotely from heaven.
God came down to Mount Sinai to deliver the Law to Moses. Unless you think God took Moses to Paradise to give him insight.
There is no defined 70th week in Daniel 9. Verse 27 is not the 70th week. Verse 27 is the sounding of the 7th Trumpet for a week of days. This is explained in Revelation 10:7.
After 69 weeks, God comes to earth. As Messiah, God is cut off. God does not stay, but promises to return at some point. The Second Coming is that point. During the Second Coming at some point the 7th Trumpet will sound. But Daniel 9 was not given to the church. It was given to the people in Babylonian captivity. That is literal.
The gap was not about Jerusalem being desolate.
"And after threescore and two weeks shall Messiah be cut off, but not for himself: and the people of the prince that shall come shall destroy the city and the sanctuary; and
the end thereof shall be with a flood, and unto the end of the war desolations are determined."
There was no flood in the first century. Daniel is still literally referring to "after the 69 weeks". Not even Gabriel nor Daniel could define the 70th week. Any who see a 70th week defined in Daniel 9 are biased because they are looking back after the Messiah has already lived. One would have to read Daniel 9 without knowing anything about the NT church nor the Messiah to avoid such bias. That may be hard, because the Gospel has gone out to the whole world.
Verse 27 can only happen at the time of the Flood and knowing when the 7th Trumpet sounds. Revelation 11 and 12. And still this is not 7 years. Without the bias of NT knowledge it may appear to be the missing 70th week. How many here are void of NT knowledge?
We know that there has never been a full 70th week, or at least we should know that. Many today claim God fulfilled the whole 70th week in the first century. In fact they use Daniel 9:27, BUT WITH NT BIAS. They spiritualize the 70th week. They remove the literal message, and insert human opinion.
They avoid the point that Satan's angels are still locked up, so how can they be cast out of heaven in the first century? It is still, not until the 7th Trumpet, that angels are cast out and a flood is sent against Jerusalem. This verse:
"And the serpent cast out of his mouth water as a flood after the woman, that he might cause her to be carried away of the flood."
happens after this verse:
"And the great dragon was cast out, that old serpent, called the Devil, and Satan, which deceiveth the whole world: he was cast out into the earth, and his angels were cast out with him. And I heard a loud voice saying in heaven, Now is come salvation, and strength, and the kingdom of our God, and the power of his Christ: for the accuser of our brethren is cast down, which accused them before our God day and night."
The 7th Trumpet is the third woe of Satan coming to earth and only then can a Flood happen as mentioned in Daniel 9:26. So then and only then will the desolation happen as written. Not just the assumed desolation between 70AD and when Jerusalem was inhabited again. The desolation that will occur at the 7th Trumpet after the Flood sent out by Satan. What is poured out upon the desolate? The 7 vials of wrath. We know Satan is only given 42 months. This is not even part of the 70th week, nor the 7th Trumpet. This is the trouble in the midst of the sounding of the 7th Trumpet. The 7th Trumpet does not stop, but has to keep sounding until the 42 months are complete, and the vials are poured out on the desolate. Then this will be fulfilled:
"But in the days of the voice of the seventh angel, when he shall begin to sound, the mystery of God should be
finished, as he hath declared to his servants the prophets."
What is finished?
"to finish the transgression, and to make an end of sins, and to make reconciliation for iniquity, and to bring in everlasting righteousness, and to seal up the vision and prophecy, and to anoint the most Holy."
John took the gospel to Asia as commanded, until captured and exiled. John knew the mystery was not resolved even then. Nor would it be resolved in 70AD. Even John knew it would not be resolved until the Second Coming and then on Patmos, God affirmed that to John. John knew the Gospel would still go out into all the world for many years to come. If Revelation is a comfort then, it would still be a comfort for hundreds of years during more persecution and martyrdom.
You are correct Daniel 9 is hard. The proof it is still a mystery, and not finished. If it was finished, we would be living in the Millennium after the Second Coming. That it is hard is proof the Second Coming has not happened yet.