We have had our 25 in Buffalo for three years. As mentioned by others, the lake can throw some steep and nasty stuff at you. But there are other times when its glass smooth. If you choose a Lake Erie cruise, take your fishing gear.
There are not many destinations on the east end of the lake. Buffalo is not accommodating to visiting boaters. Erie Basin Marina in downtown Buffalo will put you on a retaining wall that will give you a wild ride all night (and damage your boat if you're not well fendered). Don't plan on a good nights sleep. There are a few marinas on the Buffalo ship canal, but they are not usually set up for transients. Give RCR a try if you go. Enter the Buffalo River at the Coast Guard station, and bear to the right at the General Mills. The Buffalo River still has some commercial traffic, you may get to enjoy a Laker navigating the river. A few transients will anchor in the outer harbor, but thats a high traffic area, especially in snotty weather.
You can run the Niagara River down to Tonawanda, NY, which is the western terminus of the Erie Canal. There are some tie-up areas along the Erie Canal, but weekends get quite crowded and you might be rafted 3 deep. The ride up and down the Niagara River is fun, lots of flow, eddies and some whirlpools. Imagine four Great Lakes emptying through a shallow river 100 yards wide. If the wild ride doesn't suit you, take the Black Rock Channel and Lock.
Port Colborne, ON has a very nice marina, adjacent to the Welland Canal. The village is walkable and the commercial shipping through the canal provides some visual entertainment. Note: A Passport is now required to get back into the US after visiting Canada.
Further west, Erie, PA has a nice harbor and is transient friendly. But it has been our experience that, in general, the Canadian side of Great Lake border waters are newer and more boater friendly.
I would encourage you to explore the west end of Lake Erie. Sandusky, Port Clinton, the Bass Islands and Pelee Island will provide a lot of stuff to see and do.
Might I suggest considering a trip further east and north. The Thousand Islands area along the St Lawrence Seaway is an incredible area to explore by boat. Spend at least 2 days in Kingston, ON. Gananoque, ON is well worth some time. And the small boat museum in Clayton, NY is great. Boldt Castle and Singer Castle are worth stops also. Alexandria Bay, NY is a tourist mecca in summer. If you do this area, there are some good resources available on the internet.
That said, we are in the process of leaving Buffalo and New York.