Worldmark Ocean Walk had a guaranteed view category for their units. "Deluxe" means ocean front. In Club Wyndham, you have to book a 3 bedroom or 2 bedroom lock off. I didn't know that about Royal Vista. From what you guys are saying, it seems safer to stay at Santa Barbara if you want a 1 bedroom close to the Ocean. At least you are guaranteed 1200 sq feet. I've only stayed at Palm-Aire because I had a car to get to the beach and that's the Pompano location best for kids. Just avoid the Royal Palm and Queen Palm buildings if you stay there.
As far as what the OP was asking, if I was in his shoes I would still stay at Ocean Walk again. My 4 year old daughter LOVES that resort. She loves the "kids toy room", children's water feature, lazy river, and building sandcastles. She also loves the candy shop at the boardwalk and getting Coldstone, Johnny Rockets or going to see a movie. The waterpark and gokarts are also a 5 min walk from the resort for older kids. I go there twice a year myself. It's my favorite beach resort by far for a family getaway.
I live 45 mins from Clearwater and am at that beach all the time. There aren't that many "family" things to do there. There is a park right next to the resort and good places to grab food. The amenities there are more geared towards adults. They have inflatables they can play on north of the resort, but it's mainly a destination for teens and adults.
If you end up going to the Destin locations, Emerald Grande has the best amenities (Harborwalk village), but it's also hardest to book and most expensive. Majestic Sun has basic amenities and costs the same as Ocean Walk. I wasn't a fan. PCB has the best views of the ocean of all the FL resorts. I just wish they would build a lazy river and children's feature there. The non-Wyndham side of the resort has the room for another pool. This is my 2nd favorite family Wyndham beach location. Pier park, gokarts, minigolf and a waterpark are all nearby. The one bedrooms are pricy, but you can request a bunk bed so the kids don't have to sleep on a pull out.
Summary: For little kids, Ocean Walk and PCB are the best beach resorts in FL.