From everything I've seen, most people like a more versatile fan, something small that could be moved around for directed airflow. Caframo fans get good marks for low current draw, and decent airflow. I put a model 747 on my little boat. If I had kids around I'd put a ducted fan on. Some feel the price is high, but I actually got mine from West Marine when I just happened to be in a store, and they just happened to be on sale. Go me!
http://www.caframolifestylesolutions.com/products/marine/
If you need whole cabin air movement, a popular option seems to be a form of air scoop on the forward hatch. There are some that only funnel from one direction, and would be good at catching light breezes when on the hook. Others I've seen have a 4 way design that sucks air in from any direction. I think I'd try one of these before trying to install a massive fan intended to do the whole cabin. Take a look here on the chandlery store, and also the google can help you find at least 3 or 4 commercial designs. Some are like eyebrow dormers over the hatch that can even be used when it's raining.
Remember that an automobile fan is not designed for low current draw, because it is pretty much being powered by the alternator when the engine is running. As long as the alternator can handle it, they can run it, without worrying about battery draw, as the batteries are only for starting, not for deep cycle use as you would on a boat.
Also, if you take a look around on the interwebs, you'll see tons of designs for ice cooling devices that use computer case fans. The larger the fan diameter, the more air it will generally move. The slower the fan, the more quiet. A small fan needs to spin fast and noisy to move air (I think about power supply fans on my 1 rack unit servers; evil, noisy little bastards.) But a big, slower fan is nice and quiet, and most of them are 12v. You can search for "swamp cooler." Some have designs using 5 gallon contractor buckets with polystyrene cooler inserts. There is an article in Good Old Boat magazine this month of a guy who took a regular cooler, and added a fan and PVC pipes to direct the air flow. He used 2 square plastic storage containers with a mix of water and alcohol, and added a baffle to force air down into the cooler and over the containers. The containers make it easy to re-freeze at home, and also a large block of thermal mass, what with block ice lasting longer than cube ice. The alcohol blend freezes at a lower temperature, so makes for colder air than just water.