I've never had my grandchildren close by. The day my DS and DiL found out the first was on the way they also found out that DS had been offered a job abroad for 2 years! I helped with the move as DS had to start work before the baby had a passport and I retired and helped DiL move. I had intended to stay for 2 weeks but it was during lockdown and then Germany locked down so I had to come home after 6 days!
They have lived 200 miles away since their return to the UK but recently moved 100 miles closer. As soon as I'm confident they are staying I will move nearer but need to declutter more before I can downsize. The other grandparents live at a distance too, in another direction, but we all remain close. Obviously it isn't the same as living nearby, but I visit when I can, and I have a very busy life where I am. I guess it is harder to lose what you have - I never had that so I can look forward to maybe having that in the future. If you choose to move be prepared for there maybe being other changes in future. There may be things in your life where you live now that you would miss if you move, so make sure you don't do something you may regret later.