Hello from someone who is currently in this situation.
I have been living in my trailer for the past 18 months about 240 miles from my family and drive back every few weeks for a weekend.
You don't say what area you are going to or what type of work so this may not apply to your situation. The area that I am in is heavily into the oil boom so there are "RV" parks all over the place. A high percentage of them are hastily constructed with little more that dirt or rocks and very little space between units. I believe that the general population of oilfield workers don't really seem to care about much more than a temporary place to park and many are very transient.
I looked at many places before making my choice and then finally stopped at the small town police station and talked to them about the level of "activity" at the various parks. The lady I talked to told me about one that I had missed. It turns out to be the nicest one in the area. It is small, about 30 spaces, but has grass and some space between the sites. Located adjacent to the stock car track so it is noisy every other Sat night during the summer but we get free admission to the races...
My best suggestion is to take a good look around at the various parks and try to choose the best one for you. Once there try to meet the neighbors, especially if they are long term like you. Keep in mind that you can move later if you don't like it.
You should be able to make it work without great difficulty.
Feel free to PM me if you have specific questions.
Terry