Hotels/Resorts in the Bahamas?

We have decided to go there instead for our HM..more for FH to do and me too. Anyway, We cannot afford Sandals or Atlantis. Any other suggestions? I get so many mixed reviews on places.
THANKS!