Have you ever lived somewhere you didn't want to, in order to advance professionally? Was it worth it?

I have an opportunity to get a big-time job with a leading/administrative role but it is located in the central United States. I have always been from Florida and central U.S is somewhere I don't really think I would like to be at.

Though being at this job for a year or two will advance my professional career a ton due toall the experience I will get.

My question to you is, have you ever been in a situation like this before and was it worth it? What would you have kept in mind beforehand?

Thanks!