The Sheraton just did a huge rebrand and renovation. You might want to look there. I’ve always considered it the nicest hotel on the falls. Others more knowledgeable may feel otherwise.
I haven’t found hotels on Niagara Falls (Canadian side) to be that beautiful or good.
Also, are you allowed in Canada yet. If you are an American, I believe there are still ravel restrictions.