Isn’t that even argued in the episode? Like Q wanted to humble Picard when he doesn’t want to accept him onto the Enterprise as a crew member and Picard criticizes his interference. Then Q says something like “You are not prepared for what awaits you”. Indicating that he has other motives than his usual tricksterdom.

Q has always had a certain curiosity for humanity and his actions are always layered but in this instance I think the layers are only.hiding his intent on helping humanity/Starfleet prepare for threats bigger.than anything they have ever encountered.

And later he says something like “If you can’t handle a bloody nose you should go home and hide under your bed” meaning something like “if you’re out here you have to be prepared to face threats and horrors unimaginable to man.”

Oh yeah, if you use them often enough you’ll get a feel for how much pressure you can use, I’m comfortable with using a little smack to close them, but I used to work in a cocktail bar, so I have some experience with them.

I don’t know if you did that, but for anybody struggling with those:

You’re supposed to put them together at an angle, so that the outer wall of the tins forms one straight line from top to bottom. Like this:

To open it you take them into one hand, hold them on the side where they form the straight line. Then take your other hand and gently smack against the part where the both tins connect with your palm

Here:

Since tin tins are hard to break (though not impossible I can tell from experience) you could also use a hard surface and more force if needed.

If they’re still stuck, let some warm water run on where they connect and try again. Although the drink might get watery if you take too much time.

I was about to start the same list. Also - sand at day is warm and kinda soft, lying on sand at night is cold and as hard as concrete.

For starters never go camping on a beach, it’s almost always miserable.