I think you're coming from a futurist view, so I understand why you'd read Hebrews 9:28 as the second coming. I see it differently though. I take that verse as Christ appearing to the believer when it's their time to leave this world, coming for them at death.
Whether or not you believe Christ comes for the believer, I'm sure you'd agree that we'll see Jesus when we die.
Those of Old had a futurist view that all that is written shall be fulfilled when the promised Messiah the Prince would physically come. My view is only futurist, pertaining to the last day when Christ shall come again the second time. During this time, we have been in since the coming of Christ in human flesh, all the prophets foretell would come to pass within this time/age/day have been, are being, and shall finally be completely fulfilled when Christ comes again.
I believe Scripture tells us that when we physically die Christ does not come to us, we go to be with Him in heaven a spiritual body. That is not when our physical body shall be raised and changed. Our mortal body of flesh will not be raised or resurrected immortal and incorruptible until Christ comes again.
I believe the life we receive from Christ is eternal, and even physical death cannot take away the eternal life we possess when we have been born again. For that reason, Scripture shows us that when our body of flesh dies, our spirit returns to God who gave it. Also, Paul indicates that when we are absent from our physical body, we shall be present with the Lord. Paul tells us that man possesses both natural body and spiritual body, and that when our natural body is dead it is raised a spiritual body. That's why Paul looked forward to the day when he would be absent from his mortal body of flesh and death, to be with the Lord in heaven as spiritual body. Only that which is spiritually alive through Christ's Spirit in us can ascend to heaven after physical death because our eternal life we receive when we have been born again exists through spirit and not flesh & blood. Since flesh & blood (mortal man) cannot inherit the Kingdom of God, our flesh must wait in death until the last day when our body too will be changed from mortal to immortal and corruptible to incorruptible.
Ecclesiastes 12:7 (KJV) Then shall
the dust return to the earth as it was: and
the spirit shall return unto God who gave it.
1 Corinthians 15:44-50 (KJV) It is
sown a natural body; it is raised a spiritual body. There is a natural body, and there is a spiritual body. And so it is written,
The first man Adam was made a living soul; the last Adam was made a quickening spirit. Howbeit
that was not first which is spiritual, but that which is natural; and afterward that which is spiritual. The first man
is of the earth, earthy: the second man
is the Lord from heaven.
As is the earthy, such are they also that are earthy: and as is the heavenly, such are they also that are heavenly. And as we have borne the image of the earthy, we shall also bear the image of the heavenly. Now this I say, brethren, that flesh and blood cannot inherit the kingdom of God; neither doth corruption inherit incorruption.
2 Corinthians 5:6-9 (KJV) Therefore
we are always confident, knowing that,
whilst we are at home in the body, we are absent from the Lord: (For we walk by faith, not by sight:) We are confident,
I say, and
willing rather to be absent from the body, and to be present with the Lord. Wherefore we labour, that,
whether present or absent, we may be accepted of him.
Philippians 1:20-24 (KJV) According to my earnest expectation and
my hope, that in nothing I shall be ashamed, but
that with all boldness, as always,
so now also
Christ shall be magnified in my body, whether it be by life, or by death. For to me to live
is Christ, and
to die is gain. But if I live in the flesh, this
is the fruit of my labour: yet what I shall choose I wot not. For I am in a strait betwixt two,
having a desire to depart, and to be with Christ; which is far better: Nevertheless to abide in the flesh
is more needful for you.