Can some of my DVRs connect via MoCA, and others via Ethernet or Wi-Fi?

Yes. With MoCA enabled in your home, devices can connect to your home network using MoCA, Ethernet, or Wi-Fi. For Wi-Fi, you'll also need a wireless router or gateway.