Just because there is a chance for a water leak you do not have to consider it a wet location. That's kind of crazy. Thing abut your average basement or crawl space.
A quality motion light, like a RAB Stealth, can handle 1000 watts. But you have to pay money for it. They are not $14.95 like the JUNK in a home center.
Even the RAB Gotcha is 500 watt rated and they are not expensive.