Captain Worf should turn out to be a holodeck adventure because that's the only way Worf can be captain and every episode ends with him saving the universe then sadly saying "computer, end simulation" and going to bed.
(the transporter room with "Mr Adventure" was on Earth, rather than Spacedock as I'd always assumed)