I have given it a chance and it flopped horribly! Though admittedly I may have had an atypical run of bad luck with it. However, my Visual Novels with their internet DRM I have never had any kind of issue with(I can't speak for their internet distro though, I like my hard copies!).
Anyways even baring all that there is the no-resell issue. There is some moral dissonance between Steam and I there. Not enough for me to say Steam is a horrible idea or sucks(internet distro is GOOD thing and at least Steam is trying). However, add that to my thus far lack luster experience with it and I am not sure I want to send any money their way. So if 2k games/firaxis had multiple distro options I would pick the one most to my personal preference. But this 'you are either with us or against us' issue of locking you to one form of distro is not only nonsense but actually goes against what having internet distro was supposed to help(i.e. provide choice for the consumer).
So long story short the resell issue isn't enough alone, but since it failed me horribly when I gave it a shot I have been rather much finished with it. I might pick up CiV off it(since I have no other choice if I want to buy the game), but I won't pay top dollar to the Steam service so it will have to be on an uber sale, and even then it would be iffy.
Though speaking of Steam service. They have done some things right such as making it easy to keep track of sales. The library I can see as handy, their shop browser search is handy, etc. But since it seems like it likes to break games(making you re-verify in one friend's case practically everyday until he gave up the ghost on the system), blocks reselling your license to use, and doesn't seem to want to play nice with me(I don't pay folks money so I can sit and sort out their issues, I have enough stress at the moment). . . well, unless things change or I see something I can't resist I will not use Steam or buy games locked into Steam. Thankfully stuff like Princess Waltz can keep what free time I have busy easy enough and without the Steam hassle!