Niagara Falls, Ontario is a nice place. My sister worked at a hotel on Clifton Hill for two years. Restaurants near the Falls are bloody expensive, though -- a restaurant downtown can cost 30% more than the exact same restaurant further away.
Niagara Falls, New York, however, is a hole, and should be avoided at all costs.