Quite the range of lodging in Niagara. I've only stayed at a motel once, and it was pretty awful. Gotta be very careful doing that because next door, at 3am, some of Niagara's finest happened to be boozing, smoking and arguing on the walkway/parking lot when I tried it. Though the worst was in suburban Detroit when I booked a motel to just rest our heads before hitting the road again and it turns out it was right beside a strip club with our window overlooking the entrance. Turned on the TV and it was amateur porn, but just that channel was in black and white for reason even though it was recent.
Other three times or so was at proper hotels like the Embassy Suites, etc from Groupon or Wagjag deals or a comp. transfer from your wife's degenerate gambler coworker who plays the cards till 6am on a weekday and then drives the hour back to just make it to work in time.
Today was a weekday in September so got some $5 full day parking next to some of the motels at the top of Clifton Hill. Like two minute walk from the action. We all learn our lesson to not go on a Saturday in July.
Anyway, some of the Falls' typical motels. Everytime I go through NF I always say I want to explore some more of the streets. I discovered a place that rents out two and three wheel scooters for $55 for two hours. I really want to go exploring on that to check out the seedier spots. And ride around Fallsview and Lundy's Lane neighbourhoods and go fer a rip up Clifton Hill and see how well the bike makes that climb. Niagara Parkway past the border crossing I'm not sure I'd try because some cars are doing 70 in a 50 even though it's lined with B&Bs.
You can also get some escooters for $69 for 7 hours but those are skinny and don't look as fun.
https://www.thetrikers.com/fleets-rates