No. In my experience Buffy was an exception, they pulled off the stunt and it managed to work within the context of a magical universe. Most of the time these shows end up falling flat at best, cringe at worst. Not sure why Star Trek feels like they need to attempt it.
@lonlazarus@startrek The show The Magicians did a musical episode every year that generally was quite good, but again, the premise allowed that kind of fancy.