My grandparents used to visit the point by ferry via Cleveland. They really loved it. Don't count on it ever becoming chic again though. People are too dependent of their cars these days.
Really though, there is ferry service via the Island Rocket from Sandusky, and isn't there other boat lines that service it?