DLC is here to stay without a doubt. The reason DLC works is that it expands on an existing game thus increasing that games longevity. In this regards it could be argued that it is worth paying for as it may mean you find yourself still playing a game that you may have left on the shelf sooner.
As long as developers keep the core structure of the game within the original product & avoid making DLC purchases essential I'm okay with it.
It's not too often I find myself praising EA but I like what they've done regarding DLC lately. In Tiger Woods PGA 13 you now have the option to pay less for additional courses if you only want to play them once or twice or pay more to have them permanently available. It was also nice that they released a trial of the recent FIFA 12 UEFA Euro expansion. Particularly considering how poor this expansion was. I was planning on getting the download but after playing the trial I didn't bother.
I usually avoid DLC in most games with the exception of The Masters 12. The Birdie and Eagle Packs probably cost me around 50 additional dollars. Of course I feel guilty paying 100+ dollars on a video game, but this game should meet my golfing needs well into the next console generation.