fix: more helpful error messages for streaming connection failures

[cwaldren-ld]

This commit pulls the stringification logic of SSE errors into the SSE package itself, and refactors the enum into a richer sum type using std::variant.