I think it just depends on the church, the pastor, and the location, whether or not the parsonage works out well. The parsonage we live in is much larger than what we could afford, and the church is pretty respectful of our privacy. However, I dislike living in it because it's worse than living under a microscope. Every bum in town knows where "the parsonage" is if they want a handout, and every neighbor watches like a hawk for any little thing to criticize, whether if the flower beds need weeded or how often we come and go. I cannot go outside or let the kids outside without being gawked at or informed of my children's behavior (whether they were "good" or "fighting") or whether or not someone is shocked that my hubby didn't have his shirt on. Not to mention, even the sweetest church people just don't get it when the parsonage needs minor repairs, like plumbing leaks or ceiling tiles falling down. You can't bring it up without looking like an ungrateful complainer, and heaven help the woman who comes after a former pastor's wife who was a perfect housekeeper!
I guess for me it would be so much easier if we lived on the outskirts of town in our own home. My advice is, let the new minister choose. It might be a dream come true or it might be his worst nightmare.