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.