So rating Holodeck episodes, gonna just lump them in either good, middle or bad. Only gonna list episodes were it is the main focus of problems or drama, and not just spending time on it, so all the little bits of Captain Proton here and there won't count, but something like Bride of Chaotica does. Stuff like the Baseball episode isn't about the holosuite either, they just use it a lot.
The Good
TNG - Elementary, Dear Data - The Moriarty episode, only complaint is it's a bit silly how easy the ship created an actual AI.
TNG - Hollow Pursuits - Barclay is addicted to fantasies in the holodeck, including recreations of other officers. We find out is no actual regulation against it. I guess the rules are slow to catch up with new tech, like today.
TNG - A Fistful of Datas - Data takes over Wild West characters giving them his abilities, Worf and Troi are trapped.
TNG - Ship in a Bottle - Moriarty part 2, not as good but still good.
DS9 - Our Man Bashir - Bashir and Garak in James Bond Rip off.
STV - Projections - Doc trapped on holodeck, begins to think he is real.
STV - Worst Case Scenario - B'Elanna discovers a Marquis mutiny program. Great episode.
STV - The Killing Game parts 1+2 - Hirogen take over the ship and hunt the crew in WW2.
STV - Nothing Human - Recreation of a Cardassian doctor is needed to help B'Elanna, but he commited horrific crimes to gain his knowledge.
STV - Bride of Chaotica - Real aliens invade the Captain Proton simulation. Fantastic episode.
STV - Pathfinder - Barclay back at it, recreating Voyager this time.
STV - Spirit Folk - Fair Haven malfunctions and characters realise crew not who they say they are. It's a fun light-hearted episode.
STV - Flesh and Blood parts 1+2 - Hirogen at war with escaped holocharacters.
STV - Human Error - Seven uses holodeck to fantasize about dating.
The Middle
TNG - 11001001 - More of a B part of the story, Riker creates a woman for some fun and plays the trombone.
DS9 - It's Only a Paper Moon - Nog hides in the holosuite to deal with losing a leg. Boring personally.
DS9 - Badda Bing Badda Bang - The Vic Ocean's 13 episode. I find it stupid.
STV - Heroes and Demons - Doctor has to play hero in a Beowulf story to save the crew.
STV - Real Life - Doctor creates holofamily.
STV - Extreme Risk - B'Elanna does dangerous stuff on holodeck to deal with all her Marquis friends being killed by The Dominion.
The Bad
TNG - The Big Goodbye - First holodeck episode. Picard plays old timey PI and is amazed at how the holodeck is so real. Kinda boring and doesn't quite get how holodecks work right compared to later episodes (the characters can leave the holodeck for a short period, other transfers like lipstick remain).
TNG - Manhunt - Troi's mum, more Picard PI.
TNG - Booby Trap - Geordi romances a holodeck character based on a real person.
DS9 - His Way - Enter Vic. The Odo/Kira get together episode.
STV - Alter Ego - Harry and Tuvok both become interested in a holodeck character.
STV - Once Upon a Time - The Wizard of Oz type thing with Naomi Wildman.
STV - Fair Haven - Janeway and the Irish Pub owner.
Was a few episodes I was unsure to count, like the Da Vinci episode on the planet, or the evil Barclay program one. Those are more characters than the holodeck itself, but they still from it just that the mobile emitter lets them loose. They both good episodes imo.