I only pass through Buffalo on my way to and from Niagara Falls, ON. The short times that I do spend there have been pleasant; I've found the people very friendly and the prices pretty cheap compared to the rest of NY state. Then again, when I get to Buffalo, I've just gone through customs. EVERYONE seems friendly compared to THAT.
The only other place in NY state that I've been to a lot has been Long Island. Good thing I was only there on business; people were mean, prices were outrageous, and there was nothing to do. I saw a couple SPs there; they weren't very attractive.