Overall Satisfaction with Stash
We use Stash locally for projects that we just don't want hosted elsewhere. It gives our clients peace of mind, as well as gives our developers the tools they need for developing. Stash is very similar to the hosted Bitbucket, and recently was pivoted to be more in line with that service, however it is extremely easy and straightforward for a small agile team to host Stash compared to other options.
It can be daunting to set up a Git server for a developer. Managing it can be more time consuming than you want it to be. Stash helps you out by handling what you likely need. If you are already a Git pro, you won't need it, but our team loves the simplicity that Stash brings to our workflow without having to worry about going into a complicated Git setup.
Stash is well suited when you want to locally host repos and manage your team without having to manage everything from a terminal. It works well for small teams with big clients that don't want their code hosted off site. This can make auditing and other processes for contract negotiation doable for teams that can't host things outside of their development environment.