We moved from one extreme to the other - from high rise, high density out East to low rise, low density right on Holland Road. To be honest we couldn't get used to apartment living and lack of space (budget restrictions) so moved to a house and are very happy here.
I only really know about those complexes from reading forums, but Costa Del Sol gets mixed reviews. If you use the Search function you may find some. I'm curious as to why it still looks very empty when I pass it (regularly, have a friend in Bayshore Park). It's a bus ride from the MRT though.
Cote D'Azur - is that the very new one next to Parkway Parade? I don't know anything about but the location is great for shops, but no MRT. (Do you know that the MRT can't serve the coastal areas because they're reclaimed land?) Plenty of buses I would think. Walking distance to the East Coast. Again, search the archives, I think it's been discussed recently.
The Waterina is much further from the coast near Paya Lebar MRT at the very edge of Geylang. Paya Lebar is going to be an interchange for the Circle Line but we're talking a few years off. It's not such a desirable area but I like Geylang - have lived in the thick of it for 3 years already! Great food and transport links.
You could look around Kembangan - some friends almost took a
condo there recently, the only thing that stopped them was the landlord's attitude. You'd be closer to the city and also within reach of great food around Joo Chiat, a very interesting area. Also the Haig Road area, which is close to the Waterina.
I think you have another thread going about
condos and houses so will stop there.
Do take a
Serviced Apartment for a few weeks if budget allows - you don't have a clue about areas and distances until you are actually here.