I live in NY where the ban is in effect. It's been a welcome change to enjoy a meal without smoke surrounding you. I'm not a smoker and never have been so I don't know what the allure of smoking is. Before the ban went into effect there was much uproar from local bar/restaurant owners that their businesses would be severely affected...not sure what the true effect has been. I do see fewer and fewer smokers outside bars taking a puff between drinks. It might be valuable to look at some statistics before and after the ban.
Last weekend I ventured over to NJ and ate breakfast in a diner (NJ doesn't have a smoking ban). Although the diner had a no-smoking section, it didn't matter because the smell of smoke hit you right as you entered the front door. The place needed a good airing out. My meal was not enjoyable and I couldn't wait to leave--won't be returning to this establishment.