It all depends on price. The Roycroft in East Aurora is a great hotel, but a bit on the pricy side. The Marriott right at Harbor Center puts you right in the heart of Canalside, with great views of the city. If you don't mind a drive, a hotel in Niagara Falls, Ontario is also an option. Stay away from the Budget Inns and such. Those are used for NYC transfers if you get what I'm saying.