Ok, I did more reading and watched more videos. I'm starting to see the light now on the mid-drive. Also, regarding that guy being unable to use all the rear gears, it appears it was solely a result of his chain ring choice.

Thanks for the vendor recommendations. I'm currently picking my way through all the options on the Luna Cycle web site.