Just be aware that Niagara as a town is like Blackpool - it’s just incredibly dire and tacky due to tourism. We did it as a day trip from Toronto and had the helicopter ride from the District Airport, the tours round the falls including the boat, Rainbow Bridge and food before getting the train back again.
A night stop might be a bit much but then that’s just me!