Yes, give it a ton of time, it will open. After reinstalling the OS ( Sonoma) the issue didn’t get resolved. So I opened a chat session with apple support. He asked me to do whatever we already have discussed above and I had already tried like restarting in safe mode, complete shutdown and restart, removing finder files from the installation folder etc. nothing worked for me. At least 2 hours went by while I was talking to the support person as he was investigating. I didn’t do anything to my system other than just chatting with him. And suddenly the Finder windows popped up on my screen after a long time ( at least 2 hrs after installation). I think on some systems, there are a few other services or Finder services are taking longer to install or initiate.
The system is working fine since then.
Well, when I created another user account on my system same issue came again. I left it there, it was late night and in the morning it was working. So, in my case all that it needed was long time.
I have escalated this issue to Apple but looks like they are thing that it was a local glitch on my system that caused the issue. But it looks like many are facing the same.