I've been offered relocations to places where I would not consider moving, normally because traffic is too congested and commutes are too long for me, or the weather too cold for my sun-loving wife. On the other hand, moving isn't all doom and gloom. People are moving around the world like never before, and many thoroughly enjoy living in their new homes. They enjoy the excitement of a new place, settling in, and having fun. Once the nightmare of unpacking all those cartons is over, a vacation-like period takes place when you discover the wonders of the your new area.
Budget is an important factor too.
You don't want to find that you can't afford to live in the new area. The salary that pays for an agreeable family house in a provincial location may not even cover a decent condo in a major metropolitan area. Find out how much it is going to cost you before you negotiate your new package. If you can't move, it doesn't mean that you can't take the job. Plenty of technology out there will support your virtual presence in the head office, backed up by regular visits.