When we brought up the boat from Florida after buying her last year, we used Zeehag's solution: two $9.99 clip-on, 12V automotive fans from Wal-Mart. They run off lighter plugs in the cabin and cockpit, oscillate, move a fair amount of air and held up fairly well. One died early this year but we felt we got our money's worth, and the replacement price was right. We augmented this with a small 110V floor fan for use when in marinas (we don't have either air conditioning or a genset).
This past spring I bought four Caframo "Bora" 3-speed fans on sale at West Marine. I wired them into the cabin light circuits, one each at the foot of our forward berths, one in the main saloon and one in the galley. They don't oscillate, but they move a good amount of air, draw very little amperage and are quiet. I mounted a fifth, old Caframo that was already on board, in the head. We also have a 12V O2 box fan that we set up in the forward hatch to blow air down into the forward stateroom. And we're still using the Wal-Mart clip-ones, particularly in the cockpit.
We tend to use the saloon/galley fans early in the evening but shut them off when we go to bed. The two units in the forward stateroom and the O2 generally run on low/ medium settings through the night - we find we get better sleep if we have a small breeze blowing on us to cool down. If I wake up in the middle of the night I usually shut these down.
I have to admit, though, that down here on the Gulf Coast, we generally don't use the boat in July/August - it's just too bloomin' hot. I've thought about installing an a/c but don't want to give up storage space to do it, and then there'd be the need for a genset (maybe a portable Honda) to run it out on the hook. Haven't quite made that intellectual leap yet.
If you decide to go with installed fans, try to check out how noisy the various fans are before you make your choice. Some West stores have displays set up where you can run the fans to compare airflow, noise, etc. We chose the Boras based on moving a fair amount of air while being relatively quiet. Some of the other fans moved more air, but were a lot noisier.
Mike Turner
Lazyjack 32 schooner "Mary'Lis"
Mobile Bay, Alabama