Hello Italydream, and welcome to the forum,
Your question is hard to answer because it depends on what you are looking for. My generic answer is that if you have never been to Italy than I would recommend staying in the city. If you are going to engage a culture and experience it for the first time then diving in would be my choice. The typical Italian first visit is Rome, Florence (maybe Siena) and Venice. On the second trip people then usually start to explore "secondary" cities and smaller towns. But that doesn't mean you need to do it that way. If being able to relax and have the kids enjoy themselves rather than have easy access to big sights is your priority then that sounds like a good option.
My only cautions with staying in Formigine would be same for staying anywhere "outside" the bigger towns:
- Fewer options for restaurants and shopping experiences.
- You access to other places will always have the extra step of getting to Modena and then getting on a train to somewhere else. The train to Modena seems to run early until 10pm so your options are pretty good for eating in Modena late or being able to get back from a day trip without getting stuck in Modena.
For instance I don't think Ferrara is a good day trip from Formigine since it will probably be 2.5 hours each way changing in Modena and Bologna. Train travel is way less stressful than driving but 5 hours is longer than my daytrip allowance.
- English proficiency drops off dramatically in Italy outside of touristy places and with older people. The younger people who speal English head to cities to interact with the tourist trade. The Italians are super flexible and you can get by with a little tourist Italian but it will impact your ability to interact with the locals.
Obviously what you want out of your vacation is up to you and you should plan it however you want. I'm just pointing out my logistical concerns with staying rurally versus urban.
Be aware that the fast trains come into Bologna at level -4 so changing from local to fast trains in Bologna takes a 4 level change like an airport transfer so don't linger. Changing local trains is the same as any train station but Bologna is large and has a couple of track areas so it may take more walking than some cities. Also Trenitalia seems to have some bus service replacements in the middle of the day to Modena for June and bus only service Formigine to Modena in July so I suspect there is track or station work going on. Any substitutions is clearly marked on the Trenitalia site.
Have a great trip,
=Tod