You are right. There usually is no middle ground. I also love my current unit, job in the ICU, but my first nursing job I did not have those "love my job" kind of feelings. However, I must say, like you, I learned a lot in my first nursing job of which I worked a year, and met some other great nurses of which I still keep in touch.
Anyway, a move can be very exciting. I moved to a new area, new state, and am loving the change. In this economy, it's usually best to go where jobs take you. Also, good news for you, TX needs nurses, I hear, and some areas pay very well. Research the hospital that is in your small town, look up their website to see how big it is, what it's like, look up reviews on things like citydata.com, etc. Call local places, like hotels, etc, and ask them really what they think about the hospital. Say you are considering working there, but want to know if it has a good reputation, have you had good experiences there? etc. Best to get info from local people. You can do this ahead of time, and if you move, you have done your leg work. And, if not, then, that really doesn't take that long to look up the info.
If it's a good hospital, then go for it. But always look for red flags as things vary from unit to unit. Start looking at what's posted now, and look for trends. Is there postings on one unit continually, or multiple postings on one unit? If so, avoid that unit if you can. However, just because one unit has postings regularly doesn't mean it's a bad place to work, just means that unit may have turn-over because that unit always has turn-over no matter the hospital. ICU's, ER's, telemetry, and ortho units have higher turn-over rates because these are the most difficult units to work on, generally speaking. ER is stressful, lots of patients, unpredictability, whereas ICU nurses tend to burn out over time due to the emotional nature of the job, dying patients, and acuity etc. And, telemetry generally has horrible patient ratios lol.
Anyway, best of luck to you! I have never been to TX, but would like to go some day. I have a few friends in TX, but haven't gotten to make the trip down there yet. If you find that hospital has a bad reputation, then look for other nursing jobs outside of the hospital or apply to another hospital. Let us know if you go! Relocation can be fun