We moved to St. Paul from NYC four years ago - also to be nearer to our families. We have had a wonderful experience with the public schools. There is a new superintendent who is making some systemic changes, but even as that all shakes out, we are going to our neighborhood school, which is an International Baccalaureate program. There are a number of kids in our neighborhood who chose to go to another (larger) nearby school, which they also like very much. Of all the families I'm close to in the area, very few of us have children in the same schools, and we're all very happy with our school choices: montessori, arts magnet, year-round school, multi-age classrooms, etc. (I live in the Highland Park neighborhood, and I also have friends in Macalester/Groveland, Merriam Park, Lexington/Hamline, Selby/Dale, Summit Hill, and Phalen. You can google all these neighborhoods.) The main systemic change right now is a cutback in busing, which means you have to be prepared to drive your kids if you choose the school that is not your neighborhood school. But the intent behind this is to strengthen the neighborhood schools, so that's a good thing - and so far, despite the fact that our neighborhood school is also a magnet school and draws kids from all over the city, most families have continued to enroll their kids, even if they no longer have busing.
I know Minneapolis can seem the more cosmopolitan of the Twin Cities, especially coming from the East Coast, but don't write off St. Paul as an option. We really love our neighborhood - walkable (grocery, library, parks, school, shops), convenient to buses and highways (we can pretty much get anywhere in either downtown area without 10-15 minutes) - quiet, lovely, great architecture, lovely people.
Good luck!