Well no, not just produce. You'll find a section for general shit even in the smaller stores. Like tape, glue, underwear (at least for women, usually really thin cotton ones and I'm furious they don't sell the same for men, but I've still used them very comfortable). You can find basic household items like cleaning stuff and diapers and everything you need. but like the selection of tapes or glues won't be anything akin to a proper department store or a hardware store.
You can definitely find dog food and laundry detergent in all stores. And I mean it, I've worked in a bunch basically Kwik-E-Mart style shops and they all had those as well
But hypermarkets will be like almost on the level of specialised hardware stores in their selection of actually usable things. And they'll have bikes and whatnot.
Basically the sizes go with the square footage of the market in Finland at least, I don't think it's to due with what is being sold. And at one point only smaller stores were permitted 247 opening hours or sunday opening hours, whereas larger stores would only be open from 7-21 or something. Nowdays they're actually open 247 as well.
But they can only sell alcohol from 09 to 21