banff50:
I'm no expert, but I think there's a lot of hogwash in the responses you've received.
I do agree that you need to let your operator know your experience level. Most dive ops will put like divers together. If they know you are new, they won't put you on a boat going to Devil's Throat. I disagree that the best way to do this is to ensure you are with a large boat, as has been advised. Find a smaller operation would be my suggestion.
Re drift diving - taking an AOW is a fine idea, but what if the diving in your area doesn't provide drift? like if the OP is near Banff, for example? I think that again, advising the dive op of your experience, and asking to do some of the "easier" dives will get you the drift experience. Go to Paradise; don't go to Barracuda. How on earth do you think so many people actually GET certified in Cozumel, without doing drift dives before they do their AOW?
Re night diving - I like to take newer divers out from shore for the first time, usually in front of the Caribe Blu Hotel (between there and Papa Hog's dock). Ask to have a DM with you. Go in at twilight and it will become dark while you're underneath; you won't even notice it.

Until you go "Hey! I'm doing a night dive!" and I think you're on the right track wanting to do a night dive during the full moon. On a shallow dive (like the one described above which is about 22' or at Paradise which is about 43') you will see the moonlight reflect off the bottom, and it will be magical.
Oh - and don't pay much attention to the "the boats are out to get you" post (JMO). The boat operators are very aware of where the divers are in the water, and it is unlikely that you will have to get on a different boat and then swap back to your own... your boat will be there when you surface. Also, expect that when you and your buddy are LOA, you will surface. The DM will not end the dive for the entire group when the first person becomes LOA. Ascend slowly, do your safety stop and finish your dive.
Have a good time. Know your limitations and dive within them. Get extra assistance if you feel you need it; the suggestion to hire a private DM may work for you. Let your operator know what you need and expect, and then make sure you get it.
kari