Good that you brought this topic up...
One of my friends actually bought a watch purely because it is a limited edition. His reasoning is that the price may increase because it is a limited edition watch. However, it was limited to over 1000 pieces.
For me, I also don't believe in the LE hype. If I tend to love a watch, and it is LE, then it's a bonus. I agree with Ken that for some brands that overplay the LE strategy, I tend to stay away from it. For example, one of the Big 3 Swiss is notorious for having way too many variations on one of their popular lines. There's a version for almost every basketballer, racer, celebrity you can think of... THAT is a big no-no for me. The brand makes top quality watches but because of this, it diminishes the value of the brand in my heart.
Having said that, I'm not entirely against LEs. I would much rather Kari make less than 100 or so Observatoires than him going on for another couple of decades and making 1000 of them. But I believe a LE must be backed up by a very unique quality, not just a dial colour change of a common model, or have somebody's signature etched at the back. At the end of the day, it's the qualities of the watch that's the deciding factor and not just a mere number of production.
To conclude, limited edition is good when executed correctly. A perfect example would be, say, RL PLM. Lange does NOT make non-LE watches with enamel dials, and the movement of the RL PLM is not shared by non-LE models, the watch is technically superior to a regular RL, and there is only 1 variant, 2 metals (so far). So as long as Lange does not release another RL PLM with a hunter case back 2 years later and another one in tantalum, it's perfect.
Another term is Limited Production. Personally, I may favour a Limited Production more than a Limited Edition depending on the situation. A watch from a small independent may be LP but still exist in much smaller quantities than a LE of a main manufacturer (eg. DB15 vs, say, IWC Da Vinci Kurt Klaus Perpetual LE of 1000 pieces).