I can certainly understand the attraction of LP's, and I'm not surprised it's remained a strong niche product - the sound of a well setup system can be compelling. I once read a post by Stereophile's John Atkinson stating although the lows and highs on LP's have issues, the mid band was equivalent to high resolution (20-bits).
Although I've more than once considered adding a turntable to my system, the tinkering and maintenance involved with LP's has always discouraged me - I just want to actively listen to well reproduced music. I know the recording and mastering processes are by far the most important aspect of music reproduction. And although I do enjoy well sourced and mastered RBCD's, to my ear SACD's sound more open with more dynamic contrasts and air than RBCD. I've found many of the SACD's in my collection can also be quite compelling.
Unfortunately neither LP or SACD provides consumer availability to many artists/titles. Perhaps computer audio can ultimately bring the majority of listeners and music together by offering different sound resolution at specific price points for various devices.