Bembridge and Sandown are both very friendly with good runways. If you're going to Sandown, after landing ask for taxi to the flying club to pay your fees, it's the same price but that's where the best grub is, and the pilot get's a free cup of tea.
Bembridge has a hard runway, it's strictly PPR and radio only (because it's main function in life is as a flight test airfield for Britten-Norman), but don't let that worry you unduly. It's very friendly, and the Propeller Inn next to the airfield does a superb lunch.
Easiest and most scenic VFR route to the Island is Chilbolton (radio dish next to the airfield is used as an unofficial VRP by Solent Radar), South down the test valley to Romsey, DR to Totton, DR to Lymington (over the New Forest and past the Beaulieu river), cross the Solent to Yarmouth, which is the shortest crossing and at which point Solent Radar will usually cancel your service. Depending upon time in hand you can then either straight track to Bembridge or Sandown, or turn right and following the outside of the Island, turning at the needles and running along the South side of the island. Watch out for the couple of paraglider schools that use the cliffs, but other than that it's a very straightforward and truly gorgous flight.
Take care with heights en-route, you'll be ducking under the Southampton-Bournemouth class D.
G