This is a huge process and you need to really delve into the research.
It's not enough to "want to work with video game designing or sports." That's a wide range of interests, and your son's father needs to get training or take courses so he is up to date in the ever-more-sophisticated video field, and he needs to understand the competition. It's not for someone who likes to play games, but someone who is into the technological part. What does he mean by "sports"? Coaching, training, broadcast, writing, playing? Again, very different skill sets for each one, and competitive fields.
Cannibis friendly - that's growing (no pun intended) but again, you need skills to work in what is an entrepreneurial field and some local opposition even where it's legal. Massachusetts is in the early stages of this, with the first stores opening recently. Western MA is rural, and towns are small. But it's -2 degrees today, a big change from Louisiana. Your child will be needing preschool soon, and public schools in 4-5 years. So you need to understand that rural communities have regional school systems because they can't afford the whole thing alone. So you're looking at longer school bus rides. And from the time he's ready for play groups (starting now), you're going to have to work much harder to find a community with enough programs (even informal mom-and-me play groups) to keep him engaged and stimulated.
It would help if you could say more about your qualifications and your son's father's skills and background.
In general, be absolutely sure that at least one of you has a firm job offer, that you have researched housing costs including property taxes and utilities (oil heat is killing budgets in this polar vortex mess and climate change), that you factor in the move costs, and that you have a strong school system for your child. Be sure you have plenty of savings before you undertake this, and that you are totally realistic rather than living a fantasy that there's a charming and affordable house in the woods that's in a town with great schools and fun businesses and a good public works staff so you get plowed out in the winter or protected from fire in dry and hot areas (think of CA this past year).