Both are excellent.
Bembridge has better food on and near the airfield, and (if such is your preference) a concrete runway. Alternatively Sandown has more interesting aeroplanes to look at if you're thus inclined and several public footpaths intersect the airfield.
Frankly not much in it.
G