-I like having a DRO on a machine but there's always the chance that something has rendered it inaccurate.
The glass scale type are on the fragile side, a bit finicky to shim at installation, and when the seals allow liquid in they're shot. Cannot be shortened.
The magnetic scale type are on the bulky side and can be susceptible to metal chips (from reports) or a magnet. Can be shortened.
The electronic type (Spherosyn, Micro-Syn, etc) I have no long term experience to comment on.
There is no "best" because there's a mix of features, resolution, accuracy, and durability so your choice is about what you need and what machine it's mounted on. Any of them may also limit the travel range due to the physical space they occupy. The one thing that does seem to hold true is whether it's a reputable maker (Sony, Heidenhain, Newall, etc.) or not. The cheap unit from Chi-Wan are a **** shoot and should be considered disposable after a short time. A good DRO is expensive, that's why I only have one (Heidenhain) on the jig borer for close tolerance work. There is no "best" but there certainly are many contenders for "worst" on E(vil)-Bay so do some research beyond the advertising before plunking down your money.
For milling/turning/grinding I accept the potential error factor of wear in the lead screw and creep up on a target dimension while keeping track of progress with calipers/micrometers/indicators as tolerances dictate. Yes that's slow but I need accuracy over speed. JMO.