I know there is weak evidence for U/S in general but clinically I have got quite good results treating other bursa such as G troch (unsure if its bursa or gmed tendon etc) and ITB.
My application varies from classical recommendations, however. I aim for light to moderate symptom reproduction during the application and adjust intensity as accommodation/sensitisation occurs. I typically use the highest intensity tolerable and long Rx times (10-15min) and usually keep it on continuous but may flick to I/T if symptoms build. Don't ask me why it works; I could speculate numerous neurophysiological effects that all lack sufficient evidence. Perhaps the lack of evidence for U/S stems from very conservative dosage parameters studies in research - I was taught this approach by a clinician with over 40 years exp and it seems to work. Though I haven't used it on an ischial bursitis/area pain.