I am working on an Article that discusses DoF and just how the Aperture affects what is in focus. I may just put up a simple version of it to start.
But it sounds like you are getting the basics.
There will be people telling you that you need to Focus Stack in order to get every thing in focus, and it does have it's place at times. But for years with Film, there was no focus stacking, we used Hyperfocal distance to get our shots in focus. And I would have to say it must have worked pretty well since there are tons of awesome film shots that were shot.
There are a couple of things to remember in no particular order.
1. DX (crop) cameras will have more DOF then FX (Full Frame) cameras at the same F Stop (aperture)
2. For each lens there will be a range of F Stops that will be the sharpest, usually f8 to f13.
3. Diffraction. It is an optical issue that softens an image at the extreme F stops. So for example, while F22 will have more of the image in focus then say F11, it may not actually appear that way because Diffraction is softening the image so visually it's taking away from what's in focus.
4. At any given F Stop, say F8 for example. At 16mm at F8 there will be a much larger area in focus, then there will be at 50mm. Basically the more you zoom in, the tighter you get, the less that will be in focus. So sometimes its better to move closer to an object so you can shoot wider then it is to simply use a longer lens.
5. Hyperfocal Distance does work. Now when using it, if you read it will talk about being perceptually in focus, especially on the far end. You can use HyperFocal to get everything in focus, and it will "look" in focus. But now if you pixel peep, you might find it's not totally as in focus in the distance as it is in the foreground. But if you look at your print normally, it will perceptually look in focus. And personally I find it more pleasing and helps to add depth to an image anyway.
Hope those thoughts laid out help. There might be more, but I am getting hungry...
