We are doing Niagara on the Lake trip every year sometimes 2-3 times per year. It is 5 hour trip sailing in a good wind and 4.5 hour motoring if there is no wind. Niagara on the Lake is a busy place and they don't like visitors for a week. We usually call at 5 miles out and they will invite you to fuel dock and in most cases find place for you. If it's your first time spending a week in Niagara will be ok but after fist time it may get a bit boring. Another place to consider is Port Dalhousie Peer Marina. They are not as nice as Niagara but on the positive side they always have space there so if Niagara for any reason turns you down you can move to Peer Marina for a day or two and come back to Niagara. Another good place to visit is Wilson, NY. We stay at Tuscarora yacht club and it's nice, quiet and in park like settings. If you are with kids you will like it. I would suggest split trip between Niagara and Wilson. Wilson is only 11-12 nm to the east of Niagara.
We have a hunter 29.5 next door to you at TSCC and we just come back from 10 days trip. 5 days Niagara, 1 Youngstown, 2 at Dalhousie and 2 at Wilson NY. Just plan for a good weather window and you will be good. If you leaving in Jul-Aug try to leave early so you get in before any local thunderstorms have time to form.
other than passports is there anything else we would need to take if we decide to go to wilson. btw we are probably only going to spend one day at each marina and just take it slow and stop at a few ports to and from ontario place. the kids can't handle a long sail at this point. so it will be baby sails every day ...each day getting us closer....i guess what would also be useful to know is which ports enroute to niagara are the best to experience with kids. thanks again