I’ve been using one of those for a good couple of years now and they’re really quite useful in a variety of gigging situations.
Mostly I use it with my upright bass or SLB300 for jazz gigs (clubs, bars, theatres). With or without drums it produces a good well-rounded sound and is more than enough for me on stage. I would normally be going through a PA too though via the DI so it doesn’t get pushed too hard.
I actually prefer the sound of the 802 N 300 to my previous CMD121P for electric bass as I think it produces a better representation of the actual sound of the bass going through it. To my ears the 121P had a tendency to sound a bit woofly on its own with electric bass which is why I usually paired it with an extra NY121 cab for electric gigs. I think the 802 N 300 would be a great option in the studio if you wanted to mic up an amp for example…
I’d say that like a lot of smaller amps it will lose the tone if pushed too hard on a gig. At a good mid-volume it’ll sound fantastic.