I actually loved Fontaine, but he was the exception for me, otherwise I totally agree with the sentiment. TNG and Voyager really overused them spectacularly, at least for me. At least Enterprise had the sense to take place before holodecks were invented (by the federation at least…)