According to this blogpost or whatever it is Spotify basically doesn’t pay artists, so if there’s a niche/local/whatever band you like, the best way to show support is by buying their tracks/records directly from them.
I think for smaller artists, Spotify is less for revenue and more for exposure, hoping that your music can reach new listeners.