Holiday Inn Express Waterfront -- Windsor, Ontario

This worked out just fine.  It's right next to the border.  There are plenty of little bars and things within a block or two.  There's a river-front running route just across the street.

Hilton Garden Inn -- Mayfield, OH

You like this one.  These places are usually just fine, and this one's better than most.  The bar staff are quite nice, and they have a couple of local (bottled) beers.  The kitchen is okay, though the salmon is grilled into oblivion.  I'm going to bet that's a corporate policy, not the choice of the chef.

You visited in the winter, and happily they have a good contract with a snow plowing company so that the parking lot egress was cleared by the time you had to leave for work.

The first time you stayed here, your room's heater did not work, but they quickly moved you.  The second time, it all worked right from the start.