First of all, there is a big difference between what they are proposing to build there and a "trailer park". That's the first poor assumption that most are making.
Secondly, what else would you propose to be developed on this plot of land? When I found out where it was going, my first thought was "sort of a ****** location". Regradless of what they do, it's smack in the middle of the *** end of an oldshopping center and a notorious apartment complex. Would you frequent an establisment where to one side you have grease basins, trash receptacles, and liquor boxes, and on the other 18-19 year olds doing keg stands? Fencing will only do so much.
I'll agree, I think it would have been better served further out Blackjack Road based on my aformentioned thoughts. But to imply that this will be an eyesore on the community is ridiculous. It's in a poor location that I think would have otherwise gone undeveloped short of razing the old shopping center. Out of all the things the City of Starkville has approved/not approved, this decision is far from the worst we've seen.
Edit: Furthermore, I'll concede that the LFL reference had no real basis in the argument and was included solely to get your goat. You seem as animately against this as your are for the LFL (as you should be). I just don't understand your strong feelings against the RV resort.