Ripley's Aquarium is pretty cool, it's right beside the CN tower. There is also Steam Whistle Brewery right there and you can go in for a free sample. Niagara is the more touristy spot like Josh and Thom mentioned. For some ideas maybe check out Groupon as they always have lots of discounted activities and I use them to get cheaper dinners at nice restaurants too.