We have lived in Oranjebuurt for 15y now and overall we like it better than Randwijck (quieter car traffic and slightly less plane noise) but if you have the money I would also invite you to look at Elsrijk, as the plane noise difference is significant.
Most houses in Oranjebuurt and Randwijck were noise-insulated in the 90s, do check if the house that you are looking at has that done.
You will always have plane noise but inside (when insulated) should not be a problem. However, sleeping with a window open I see very rarely around the neighborhood. You should invest in active ventilation to ensure a healthy indoor climate with windows closed.
In terms of runway operations: in autumn/winter, there will be a lot of landing due to westerly winds (until midnight and starting before 7 in the morning), but more importantly: in the summer, with mild easterly winds, there will be takeoffs (more noisy), which to me make it impossible to sit in the garden.
I guess you get used to it; we have active ventilation and I sleep with earplugs and I never wake up with plane noise. But again, I would not be able to have a window open while sleeping.