Support HTTPS in Spotlight transport #3128

Problem Statement

SpotlightTransport currently disables SSL unconditionally (connection.use_ssl = false), so configuring Spotlight with an https:// URL does not establish a TLS connection. This prevents using Spotlight sidecars that require HTTPS.

We've run into this in our dev environment recently

See: #3136