Fantastic article and a great way to explain the differences between Service Endpoints and Private Link!
Another interesting topic is also the Private Link Service (which is a different service) which can be useful for creating surfacing virtual machine workloads and enable private link endpoint connections to be created to them. Useful for scenarios like accessing SQL Server in Azure Virtual Machines in on-premises environments or another subscription/tenant from Azure Data Factory
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
For those concerned with the limitations to Private Link endpoints and implementing private DNS resolution, Azure Private DNS Resolver can help. Especially in scenarios where you need to resolve private IP addresses for private link endpoints linked to your PaaS services from a different subscription or on-premises.
https://learn.microsoft.com/en-us/azure/dns/dns-private-resolver-overview