I cannot explain the technical differences, but Apple started switching to APFS with High Sierra. This link is informative:What is the difference between Mac OS journaled and Apfs format?
Is there any disk speed difference between those and ext3 format ?
What's the Difference Between APFS, Mac OS Extended (HFS+), and ExFAT?
So you're using Disk Utility to partition your new hard drive when you're presented with a choice of potential file systems.
www.howtogeek.com
I have all SSDs (both of my Macs have internal SSDs, and I have 3 external SSDs). After High Sierra, and (it seems) if you have SSDs, they must be formatted as APFS for the OS and apps to work (or at least the partition that will contain the OS and apps).
I actually don't know about mechanical drives (HDDs) and each Mac OS after High Sierra, From that link, it seems that those newer versions of the Mac OS can work with HDDs formatted as Mac OS Extended (Journaled).