If you're looking for a full fledged service that offers SSO and that you can self host (or cloud) with SDKs for most of the popular languages out there, then I'd recommend to look at Ory[1].
[0] https://docs.microsoft.com/en-us/aspnet/core/security/authen... [1] https://www.ory.sh/
Auth0 is complete overkill if you don't need their advanced features IMO.