1.Why is a SIP address automatically created for both hybrid and cloud users?
Did you assign the Teams licenses to the users?
Based on my test, if you only assign Exchange Online license, the user only has SMTP address, and if you assign Teams license, it will create SIP addresses for the user.
2.Why some cloud users have a MOERA address created (the smtp:*@domain.onmicrosoft.com address) and other cloud users don't?
Microsoft Online Email Routing Address (MOERA) is automatically generated and included in the proxyAddresses attribute within Microsoft Entra ID, a process commonly referred to as proxy calculation.
Does the “cloud users” mean that the users are created in Exchange Online directly?
Reference: Microsoft Entra UserPrincipalName population - Microsoft Entra ID | Microsoft Learn