It depends what you are looking for - historical on the water is not something doable in downtown Buffalo. There are a lot of condos and townhouses on the water that are new - 20 years old. These are easily obtainable for $200-$500K. The more you pay, the better the amenities, views and space (of course).
This is the local mls
http://www.buffaloniagarahomes.com
Historical throughout Allentown which is the neighborhood bordering downtown is easily doable. There are many loft conversions in downtown Buffalo in historic buildings- some to condos in historical buildings. A google search should lead to the information. Be aware that many have waiting lists. Some are complete gut jobs though and the only historic value will be in the facade.
As far as safe - the Buffalo area is quite safe. Like any city (town, rural community) it has crime. Your best bet would be to buy west of main street.
Buffalo definitely does not have a NYC skyline. If you expect that, you will be disappointed. As far as snow - you will learn to drive in it. The best advice is to go slower then you normally would drive. Downtown will get snow, however it is 15 miles away from the snowbelt making the accumulations far less than expected.