I think my favorite representations of the holodeck were very early in the series: the lone fight opponent Yar created in Code of Honor, and most especially Yar's memorial service. It looked...good, but very definitely not quite
real. I liked it better that way.
I think the holodeck needed a "range limit", of some sort to tie it down before the concept ran astray. But I guess it was inevitable.