There are a few exceptions for enhanced drivers licenses from a few border states, or something called a NEXUS, but you can no longer drive there with just a normal US driver's license, unfortunately.

That said, the falls are also amazing from the US side, so you should still go.