You'll love CBR, but if you're going to pay extra, you might as well pay extra to be in a preferred location (areas in Martinique or Trinidad North close to Port Old Royale) -- I wouldn't pay for the water view.
On the other hand, some of the standard rooms can still offer you a beautiful view, as the whole resort is beautiful. As Safetymom has commented numerous times in the FAQ's for CBR, you probably won't spend much time looking out your window anyway.
Some of the best views come from sitting in a chair or lying on a hammock on a beach close to your room, or from walking the Promenade around the resort. Regardless, you'll have a great time.