Question about St. Maarten

I'm planing to go this summer to the aviation photographer's paradise.
However, my internet search produced too little information. Now, for those
of you who have seen pictures or have been there, how's that hotel on Maho
Beach called and what's the typical cost of a single bed room per day in it
in the middle-summer season? Also, which airline did you fly there with? I'm
thinking of going by either KLM or Air France, but since I'm in Croatia,
some time away from CDG or AMS and need a connecting flight, I'm seeking the
cheapest way. And yes, what's the predominant weather pattern there i.e.
which runway's most commonly in use?

Thanks

Triple Delta