bottom of the room would be best as it would allow the cool air to rise from the bottom of the room and cool as it went up to the air cooled hood.

Putting it at the top wouldn't really cool the bottom of the room very well, and this is where your plants are. You want to create a cool buffer between the canopy and your lights.. which a hole at the bottom would do that much more efficiently than a hole at the top