Plaza · Central Business District · 520 Vine St (at 5th St), Cincinnati, OH
Chris Thompson: For great photos of the fountain: set your camera on a tripod and use a long exposure (2-5 seconds) to capture the running water. Get Carew or the colored lights above Rock Bottom in the background.
Scenic Lookout · Central Business District · 441 Vine St (at 5th St), Cincinnati, OH
Chris Thompson: Provides some neat photos of the highways snaking around the city. Set your camera on a tripod and use a long exposure to get moving car trails. It's only open at sunset a few days each year.
Fire Station · Hyde Park · 2733 Erie Ave (at Michigan), Cincinnati, OH
Chris Thompson: One of the most beautiful historic firehouses in all of Cincinnati. The firefighters here are used to having their photo taken while they work. Ask nicely and you can get some cool shots.
Garden · Walnut Hills · 1501 Eden Park Dr, Cincinnati, OH
Chris Thompson: The Conservatory hosts several photographer nights during the Butterfly Show each year. Pick one of those evenings to avoid kids getting in your way. Don't be afraid to get close to the butterflies.
Chris Thompson: The overlook next to the Drees pavilion affords a great view of the Cincinnati skyline. Shoot at sunrise or sunset for the best lighting. Underexpose slightly to get the city lights just right.
Bridge · Court Ave. (KY17) (btwn E Mehring Way & Riverside Dr.), Cincinnati, KY
Chris Thompson: The new lights on the bridge create excellent stars when you photograph them using a narrow aperture (~f/16 and above) on your camera. That means you'll need a longer exposure (and thus a tripod).
High School · 13 Carothers Rd (Carl Foster Dr), Newport, KY
Chris Thompson: My favorite spot to shoot the Riverfest fireworks. Bring a long lens and a tripod. You'll want a long-ish exposure (5-10 seconds) to capture the bursts, but make sure the skyline isn't overexposed.
Park · Central Business District · W Mehring Way, Cincinnati, OH
Chris Thompson: The colorful fountains make a great subject, but you need to use a relatively fast shutter speed (>1/20 or so) to catch the lights before they change color, leaving your pic with plain white lights.