We've gone down this route with Java and my conclusion is that declaring the kind of errors a function returns is, for most users, just a pain.
https://www.artima.com/articles/the-trouble-with-checked-exc...
My experience with Go is that decent libraries only have a small number of error return types, and then forward or wrap errors from libraries that they use. You can use errors.Is(), errors.As(), errors.Unwrap() to figure things out as necessary.