I rate this hotel as very good, as far as Mackay lodging goes. Be aware that most of the lodging options in Mackay are a bit worn. Hotels that are full to capacity every night don't necessarily have much business incentive to renovate frequently.
I'll write a review to try to explain the variation in reviews here. It's likely they're all accurate. One thing a traveller to Mackay needs to know, going in, is that Mackay is a mining bedroom community, and that makes it more expensive than say, Sydney, Brisbane or Cairns. A property you pay $160 a night for in Mackay would likely go for $100 or less in one of those cities. So keep that in mind when reading any Mackay motel reviews that few (if any) hotels in the area are not overpriced when compared to similar-level facilities in non-mining towns, and also that it's virtually impossible to find a "deal" at Mackay hotels, since most fill up to capacity every night without having to offer any kind of discount.
The reviewers who talked about the helpfulness of the hosts at the Mid-City are right on. The people who run the hotel are very friendly and accommodating -- it impressed me as a real family business run by people who still enjoy the work that they do. One thing that hasn't been mentioned is the pool, which is a nice tiled affair that sparkles nicely in the sunshine and, while not in absolutely perfect condition, is still quite nice. It's the nicest hotel pool in the vicinity of the Mackay CBD for "hanging out at", and there's a grassy courtyard area outside the pool surround where younger kids can have a bit of a run around as long as you watch them. A few blocks walk directly west along the river is the free Bluewater Lagoon, a small city-run recreational swimming area well-suited to amusing your kiddies. So if you have kids and they like the water, the weather's good, and you're travelling up through the coast and stopping for a night or two in Mackay during stinger season (which makes ocean swimming a bit of a hassle what with stinger suits and all), this motel is one I'd consider for your "short list".
An FYI on local pools. The best motel pool in the area (small but clean and with a shallow ledge area you can sit on with water up to your shoulders) for *adults* who want to lounge in or near a pool is probably still the one at the Clarion at the Marina, but that's a ways out of town and more "off the path" of the Bruce Highway that is the main north/south route through town, and I believe the Clarion recently established a smoking area right near the pool, so it may not be as pleasant a place to hang out as it was a few years ago. If you like to do laps, the public Memorial pool is a half dozen blocks or so from the Mid City, and while it's not free like the hotel pool or the lagoon, the entry fee is modest and the it opens pretty early and stays open until the early evening.
I believe the Mid-City has an outdoor barbecue you can use as well (check with them if that's important to you), which is a nice Mackay touch. Like much of tropical Queensland, Mackay loves its outdoor barbecues... city-maintained gas grills can be found around and outside town at parks and beaches, and even outside the city information center on Nebo Rd.
I've stayed here multiple times in a several-month window, in several different rooms, and had different experiences with room upkeep, cleanliness and smell. One stank like tobacco even with the window kept open all night, and seemed a touch mildewy, and I had trouble breathing in it. Others smelled fine and had no sign of mildew. One problem motels face is that if they're all booked out into the future, and a guest smokes in their room figuring that they're a rich tradie who doesn't mind paying the $NN fine for the convenience of doing their own thing in the room (the "if I get caught, I'll just cop the fine" mentality is pretty common in the area for many things from parking, to drunk/disorderly conduct, to smoking in places one shouldn't) someone's going to get that room the next day, and the hotel might or might not be able to take the room out of service for a deep clean without losing revenue. If you're checking in early enough and don't like the smell or upkeep level of your room, ask to try another and they might be able to accommodate you. I say might because this is a small family-run property and they manually schedule each room in advance, so depending on how busy they are and who's booked what when and is or is not already checked in, it might require too much juggling to move you to another room.
This review is the subjective opinion of a TripAdvisor member and not of TripAdvisor LLC.