I would expect page turns will be going away. You can already use your iPad as a music stand, though it's kind of small.

If you're using a real device, page turns can be automated or eased. The device can listen to what you're playing (tempo shouldn't be too hard to pick out) and turn pages appropriately. Or, you could use a foot pedal or what have you - perhaps your phone.

Apps for this sort of thing already exist, though I don't know how good they are.