I recall one episode of DS9 that took the idea of “solar sails” to ridiculous proportions by having a ship made of wood, with sails that needed to be operated by hand.
Despite the simplicity of the craft, they even manage to go FTL, though admittedly only because the sails got pushed along by tachyons.
Science!
There is an episode where Voyager is hit by a Borg weapon, starts to spin , and Paris manages to get her in control and back into warp in a second or two.
Paris does seem bored most of the time.
What about the Holodeck?
First, people seem to be able to travel distances much greater than the deck or even the ship itself.
Nobody has sex with anything? Not even the most attractive crew member of their gender of choice?
Sometimes crew members get injured in the Holodeck but other times they aren’t.
Anything else?
I don’t think it’s been canonically addressed, but I assume the floor is a sort of omni-directional treadmill.
In TNG, Ensign Barclay had a holodeck program featuring a holographic Councilor Troy, for implied sexy purposes. Pretty sure it’s canon that Quark had “adult” programs available in his holosuits on Deep Space 9.
And then there’s Lower Decks, which featured a full-on holodeck orgy.
The holodeck has safety protocols which prevent anyone from being hurt, but they can be overridden with sufficient clearance, and occasionally go offline on their own when there’s significant ship damage. They’re usually pretty explicit in the script about the safety protocols being disabled when it happens.
Indeed. They can be miles away in a 10 metre square room.
Dr. Crusher: [outside of the holodeck, to Wesley, who is inside] Wesley, You’re spending too much time in the holodeck. I want you to see Counsellor Troi.
Wesley: Um… She’s in here with me, mom!
I want to know who cleans up the spooge.
I think the idea is that the safeties (when they are working) are supposed to keep you from being killed; but sprains, broken bones, and such are allowed. I presume the safeties can be set for ‘zero injuries’ from holographic characters and situations, but the people want to have ‘acceptable risks’.
Your holodeck ref made me think of Barclay which made me think of the worst occurance of “We’ve discovered this amazing tech thats never seen again and would break everything!”
Usually its this crazy ancient artifact…but in the second (I think) Barclay episode, he uses readily on hand equipment to not only increase deflector shield use…he invents Starfleet transwarp drive. Everything he did should be easily repeatable. Its all recorded!!
I know that Lower decks makes a passing ref to this trope, but I want to see an entire Lower Decks ep dedicated to this! A Department of Useless Anamoly and Artifact study. DUAA!
“We tried to replicate telekinesis with this kironide stuff and all the test subjects died!!”
'Yeah…DUAA!"
“Someone might want to check on Kirk and Spock.”
An entire ep showing cynical officers fanwanking why the feds dont have:
A giant neutronium paper weight
Telekinesis
transwarp
Soul transfer devices
All of Methuselahs stuff
Garths abilities
Scalosian tech
Im just gonna stop there…i went from memory to looking at a TOS ep list (Goin backwards) and im only halfway through the third season.
OK one more: Jesus Christ the Spock’s Brain tech.
That’s what ensigns are for.
Nitpick: Troi
Yes, it is canon that Quark ran porn in his holosuites. It’s mentioned several times and he even tried to record Kira for a client who was interested in…well, that was never specified, but easy to imagine.
I’ll hand over my agonizer.
On the holodeck sex thing, I’d always put it down to a combination of:
It’s like going to the toilet…it happens, it’s just not shown
It doesn’t feel good. The holodeck is supposed to be holograms and forcefields. Maybe the sensation is a bit uncanny valley (so to speak) and so people still very much prefer the real thing.
(Although, of course, in the real world, very poor sex substitutes are nonetheless very popular, including just watching someone else have sex).
On Lower Decks Mariner got the job. She also has an “all nude male Olympic training gym” program.
Someone get me a vimto
Trek is practically built on tropes that by the time we see them wouldn’t even merit a conversation (Prime Directive…holodeck stuff) but always the crew acts like this is the very first time this amazing thing came up and doggone we have to wrestle with the moral implications right here and now!! The fucking PD should not be a philosophy up for debate.
“Hey this emergency holodoc is very grumpy and seems to be developing sentience when we leave it on all the time!..well thats just crazy!”
Again Lower Decks is the perfect place to cover this.
“A temporal anomaly passed through your quarters while you were gone. It seems 100 years passed in your room in a minute! You didn’t leave anything on did you?”
“Just the toaster…oh God.”
“I AM TOASTARIO!! SUPERIOR IN EVERY WAY OF HEATING!! ALL TECHNOLOGY MUST BOW TO ME!!”
I was thinking about this just yesterday - Wouldn’t the process of being torn apart molecule by molecule, over a period of several seconds, apparently whilst still experiencing continuation of concsiousness, be a bit hurty?
In The Devil in the Dark (TOS), I noticed DeForest Kelley kept referring to the silicon lifeforms as silicone.
That guys “Fed officer accent” sounds just like my Matt Berry impression
Given what he had the “Shore Leave” planet make for him, I’m not surprised.
I LOL’d. 
Which brings us back to amazing tech we never see again…McCoy was brought back to life FFS!!
And the trope of “How the fuck are anyone on these Constitution class ships still alive??” What SHOULD happen:
“Captain I just saw a giant white rabbitt who said he was late”
“Spock beam everyone up immediatly and move the ship out of the star system. I’m beginning to think its a bad idea just beaming command crew up and down willy nilly to these planets instead of a team of dedicated, hazmat suit wearing scientists.”
OR
“Captain we’ve discovered a small planet that seems to be only a few thousand years old.”
“Really?? Welp guess Ill beam down with the Chief Medical Officer, helmsman and…ohhh…give a geologist to make everything seem on the up and up”
Curiously enough, I always thought that was deliberate; the closest analogues to carbon macromolecules in silicon chemistry are silanes and silicones. It might be possible to imagineer an alternative biochemistry based on, or incorporating, silicones.
Mind you, that doesn’t explain how the Horta could pass through solid rock. They would probably smell like burnt rubber, too.