Manteca is definitely a city with a small town community vibe! Before relocating from Manteca, CA to the East coast for work, I lived in Manteca for nearly 20 years with my family. While I would not necessarily spend a lot of time on Main Street (other than to visit my favorite "hole in the wall" Mexican restaurant right off of 120W), there are many great newly developed areas and shopping centers to visit.
For your everyday needs, such as groceries or general home supplies, I would highly recommend the Spreckles Park shopping area. There is an array of stores and markets that can provide any of your daily essentials and when you are done shopping, there are plenty of spots to eat as well, such as Applebee's, Chili's, In-N-Out (a must if you have never had one of their burgers), Chipotle, Jamba Juice, and Starbucks, among many other restaurants, including locally owned eateries such as Mr. Pickles.
For entertainment and serious gift shopping, I like to head over to one of Manteca's newest centers called the Promenade Shops-Orchard Valley, where you can find a lot of great outlet stores and unique, fun to visit stores such as Bass Pro Shops, which everyone should visit at least once to witness the beautiful architecture inside and the indoor waterfall. This is a great area for families to visit for weekend trips to the movies, and if you head a little further west on 120 then you can also visit the Sharpe Depot shopping center or the Big League Field of Dreams where many local, intramural teams gather to play fun rounds of baseball.
Overall, Manteca is definitely a family friendly city and is really up-and-coming in terms of quality shopping, food, and entertainment.