Return Current Connection CName
The SQL Server instance has no notion of the name resolution the client used to connect to the server IP address so what you want is not possible.
@@SERVERNAME returns the server name or FCI network name, plus instance name for a named instance. The value is unrelated to the client connection specification.