Hi Alex,
I did my PPL at MFC way back when they still had a JAA programme. Overall, I was very happy with the school. It's professionally run, if a little on the busy side. But so long as you show up on time for your flights, everything will be peachy. Everyone's very friendly as well. Great maintenance department, too.
Moncton itself is a nice little town. If you're the outdoorsy type, you'll be very happy there. The night life is pretty decent as well.
The only downside from my personal experience was the length of time it took to finish my PPL. There are so many students that it became difficult at times to get more than an hour's flight per day. That said, I left just as the school began to implement a new scheduling system, which may have solved that problem.
PM if you need an more details.
TG