The app of choice for professional musicians is ForScore, and there's really no competition.
100% of my colleagues are using ForScore on an iPad for these purposes.
Great feature set, great support, stable, very fast. And page-turning is ultra-fast. If you need that to be hands-free, there are numerous hardware options for that.