Well, I'm from that area of SC and would love to move back. If I were choosing, I would choose Fort Mill if schools are a concern. Rock Hill has some nice areas, but I would stay away from the side closest to Chester. Chester has gone through a lot of mills closing; it does have very affordable housing, though. You can buy a home in the historic district for well under $200,000. Lancaster, SC, is another option; it is really growing as well, as it is also close to Fort Mill and Charlotte (which is in NC). Lake Wylie is a good option if you have a little more money, say closer to $300,000 (and up), but it's a huge lake, so that's expected. Were I going to choose, I would probably choose Fort Mill or the northern part of Rock Hill.
As far as Rock Hill's school district, I can't answer from personal experience, but my guess would be how you're treated depends on what you expect. None of the schools in the South pays as much as you get elsewhere, but the people's friendliness makes up for that (at least in my opinion). You can get a lot of answers on the Carolina Living website if you want more information.
I believe India Hook Elementary is a new school. The website for the new India Hook school is
http://www.rock-hill.k12.sc.us/schools/elem/ihes/; it shows the dates and times for parent informational meetings, which you might find helpful.
Good luck!