If it is likely your students will experience intermittent network drops, Quiz or Lesson will be more reliable than SCORM. I'll use Dan's initial phone example. Quiz or Lesson are a lot like being in the same room. If the connection drops, when it comes back up (unless you've left), both you and your stuff are still there. SCORM is like a VOIP phone call. If the signal drops, the connection is gone. You have to close up and restart. If this could happen three or four times an hour, SCORM is not worth the trouble.
SCORM is nice for making things more attractive, interactive and blending. Quiz quizzes...all the questions are graded. Lesson gives content and checks knowledge and all the questions are graded. Feedback asks for opinions and nothing is graded. SCORM allows you to do all these things with lovely media and color all together in one module (which, I suspect H5P can do--haven't tried it yet, but I've asked to have it installed on my development site!). SCORM can (if you are able) provide software tutorials, with either demos or hands on practice or both that nothing native to Moodle can. But not everyone needs that (I do, from time to time. Really, we need a lot of it, we just haven't provided it yet.)
Personally, I like SCORM, but my users generally have stable network/wifi connection. I use Lectora and Captivate, which are both pricey and can publish in different ways (I think Lectora can publish to tincan now, Captivate also publishes to SWF as well, one day they'll realize flash is dying a brutal death and who knows what will happen then, and pdf-badly). They tend to be pretty good. I've heard Articulate is good (again, pricey). I liked the convenience of iSpring Free a few years ago, but it only opened at the beginning of a module (couldn't remember where you left off, if you didn't finish) and was very sensitive to network glitches. And it isn't very good in the 508 compliance realm for the US (might not be relevant to you). That said, I get that SCORM is a dinosaur (gotta love 'em) but it isn't extinct yet.