I've never heard that story before and I just couldn't believe my ears!
I looked it up and I found that info. As you said, the UPN exec wanted a different hot band in the "restaurant" on the ship each week and then in the end credits, they can put up a card with the album info. "All the other shows are doing! Trust me!"
Holy cow! Now I have a different opinion of Berman, at least he asked the exec how are we going to get that band on the ship when they are out in space far away!
What a stupid idea!
And it also is in line with what I've heard Bakula say that the management at the studio and network are totally different and there was simply no support for the show. As I recall, the urban shows were mostly what was on UPN at the time. Star Trek just didn't fit in. Voyager ended at the right time.
I also read part of the Brannon Braga interview on Trekcore. He said something that surprised me. That if you want to see a series picked up for another season, watch it on Netflix. Apparently, the suits take those numbers seriously and one series is getting another season because of that. So he said, if you want more Enterprise, watch it on Netflix!