Turning pages in piano music is normally problematic unless the piece is short or you have a dedicated human page turner. Further, a lot of music comes in perfect-bound books whose spines need to be "broken" before the book will stay open to the pages you are currently playing.
I think it would be wonderful to have a tablet app that would not only eliminate the staying-open problem, but would listen to your playing and turn for you at some user-adjustable length before you come to the end of the current page. You could adjust it per piece, say, so that sometimes it might be half a measure or two measures, or whatever seems appropriate.
I can't have been the first person to think of this, but I can't seem to find anything like this in the Android Play store. If there were such an app on the iPad, I would consider buying one of those. Perhaps the reason I haven't seen such a thing is that it would involve a vast digital-publishing infrastructure. Or maybe I'm just not looking in the right places?