Well, I've been both a 'near home body', and also someone away. We lived the first 10 years of our married life in and around family (close by). Last 4 of those years with a little one.
Then we moved to CA for 18 months, and didn't like it at all. Partly due to the space between us and family, but mostly because of the cost. We moved back to Texas, but in Dallas rather than Houston.
What we found was that to see the family, we still had to get in the car and drive 4+ hours. In short, it was a one way visit. In the 15 years we lived in the DFW area, members of our family only came up 2 or 3 times at best. That is one thing to consider in your decision. Not saying we had bad family members, but they seemed to think it was still up to us.
We now live in SC, not too far from Charlotte. Our son is in Houston, a few other family members there. Mother in law is in Ft. Worth; some of my family in Seattle and one part in Germany.
Our life here is good. Decent job for me, off and on for the wife. My income has been tremendous. However, we would still like to move back to Texas at some point. Some for the family, but mostly for the area, cost of living, lifestyle, etc.
One thing I read in your post was the 'new job lucrative in about two years'. I'd be very, very careful about what it 'will be in the future'. If you are not getting the money when you move, it will be difficult to get it after you move - within the same company.
You need to find out what your top 2 or 3 priorities are. They should be the drivers. Deal with the big ones first, worry about the smaller ones later.
Best of luck with your decision.
Tex