To be perfectly honest, I personally prefer going out to live music events, restaurants, and bars in Colorado now that the public indoor smoking ban is in effect. There were a couple of restaurants that I stopped going to because their smoke abatement was terrible, and I really, really had to want to see a band badly to be willing to go to a couple of the smaller venues (again, bad ventilation). Conversely, one of our favorite restaurants used to have a smoking section in the back, with really good ventilation - unless you were seated right next to a smoking table, you'd never guess people were smoking in there... which told me that it could be done, but some businesses didn't want to go to the expense of installing the necessary equipment.
There were dire warnings of local bars that would go under, and loss of tax revenue - but as it turns out, a lot of the dives still exist (and I go to more of them now), the music halls still pack in crowds (and the smokers hang out under the awnings), and the only restaurant that I know of that probably went under as a result was one that almost knocked me over with the aroma of stale cigarettes when I entered - you couldn't smell the bacon over the smoke, which I took as a bad sign.
Are there problems with the regulation as it stands? Probably - I haven't run into anything serious, personally, but I'm still a n00b. I only smoke at my own house (outside) or at a B&M/lounge. Colorado's state law (as opposed to some more restrictive local laws, say, in Boulder) seems to have been a reasonably good balance, on the whole. And I think the recent state and local laws regarding marijuana legalization show that there's room for some compromise on both sides.
I reserve the right, of course, to change my mind if I hear more data beyond just my own experiences. :D