I got some great pics of the strip joints and peep shows last time I was there 🙂.
Seriously, either side offers some amazing vistas. Take the cable car ride over the whirlpool (just downstream from the falls) if you want some really impressive shots. You can also take the Maid of the Mist boat ride, but the spray is often too heavy for very good photography.