I think the perceived complexity has hurt it, as is that it falls in the crack between developer and DBA. I suspect few DBA's recommend it, and few developers know it is there. I haven't seen - though there may be - good prescriptive guidance on when to using queuing in general, and when SB is a good fit. For me the win might be the ability to easily spin up multiple threads to process the queue without manually partitioning the workload.

A start would be to make it a lot more visible. A SB task in SSIS for example.