Gord and I spent Wednesday until today in Niagara-on-the-Lake and stayed in the County Derry room above the The Irish Harp in Niagara-on-the-Lake. We stayed there last year and liked it.
There are three rooms and in the hallway are a shared Kerig coffee maker, microwave and water. Every morning they leave a pile of clean towels, etc. outside your door. It was odd they didn't leave a roll of toilet paper, though.
For every night you stay, you get a $25 voucher to be used in their pub, which we did Wednesday night on the patio (our voucher was $75).
It's a handy spot because it's downtown and walkable to everything. Parking is free if you can find a spot on a nearby street (which we did).