We've traveled extensively with all of our dogs. We have an RV so we prefer to use it b/c it's often cheaper (though gas prices are awful) & b/c it's easier than hauling kids, dogs, suitcases, etc. in & out of the hotels, but we've done both. Many hotels are now pet friendly, some charge a per stay fee for the dog(s) that is a flat rate whether you stay 1 night or 14 nights, other's charge for the pets per day, and a few just charge a cleaning fee. I've had the best luck asking the hotel reservation agent for the "best rate", but maybe someone who's worked in the hotel industry will have another suggestion for lower rates. It can be pricey to take a dog w/you to a hotel, but I still think that it's often cheaper than boarding them. Besides, I'm the poster person for over-protective mothers, so I rest better when they dogs are with us.
If at all possible, find a hotel that has side entrances/exits and doesn't require that you traipse through the main lobby whenever Sierra needs to go potty. We've done that and it was a little embarrassing with three big dogs, but one might not be so bad.
Also, first floor rooms are more convenient & if Sierra hasn't been in elevators before, she may object at first (Sam really didn't like them). Finally, if at all possible find a kennel in Niagara Falls that you think that you'd trust (and then you can check it out in person when you get there) so that if you want to take entire days to sight see without Sierra, that you can drop her off for doggy day care. Have fun!!