What prevents a passenger from opening the emergency door on his own will, mid-flight?
At cruising altitude there is between 4 and 8 tons of pressure acting on the inside of the door. There aren't too many passengers capable of exerting that much force on the handle (and even fewer handles that won't just snap off). Latch type doors have interlocks or over-center latches that prevent operation with a pressurized cabin.

It's theoretically possible to open the over-wing exits at approach altitudes when there is no pressure differential. Other than being windy/noisy it would not affect the flight in any way. Cabin doors usually open forward, good luck pushing them open against the airflow. If the person who pulled the window plug wants out, it's their (and only their) funeral. I've sat in the open doors of light aircraft in flight hundreds of times, legs in the breeze, no seatbelt, while the plane makes fairly steep turns toward the open door side. It's not a problem.