Unpopular opinion(?): Barclay’s fantasies weren’t the creepy thing about this episode. Nothing wrong with having weird fantasies, as long as you keep them to yourself, and Barclay never meant for anyone else to see his holodeck programs.
The unsettling thing about this episode, to me, is the fact that the holodeck apparently doesn’t have any usage restrictions on the likenesses of real people. They really ought to have an opt-in system for allowing others to simulate you on the holodeck.
TL;DR: He just like me fr!!!! /j
I haven’t actually finished TNG yet, but here are my picks for funniest and scariest so far.
Funniest: Deja Q
Scariest: Identity Crisis