Not a big difference, they both need to install Configuration manager client on them. You get high cloud modernization with Azure AD Join. Check the articles below:
Hybrid Azure AD join means your device is joined through on-premise Active Directory + Azure AD. Azure AD join means the device is joined to the Azure AD only. In both scenarios you can use co-management by having the device managed through Intune + ConfigMgr.