Bob - You clearly have much more experience than me, so thanks for the advice!
All in all, I am comfortable focusing on Newport. In fact my search is focused on Newport and east along the riverfront through Dayton. I have avoided Covington and west, because it appears as if Newport's success is having a negative impact on Covington's population (not whole numbers, but quality tenants).
Monmouth Street has truly come back to life recently. Google maps just doesnt do it justice. New restaurants on every block (Sis's, Packhouse, and several others), bars are doing what they do, a new development called "Monmouth Row" at 5th & Monmouth, new city buildings at 10th & 11th and Monmouth. Its a good mix of old (Pepper Pod, Dixie Chili, Knife shop, etc.) and new at the moment. I would argue its better to move out some of the strip club and gambling and move in more family friendly businesses, but its taken some time to find that balance. And It's funny you mention the Ovation property (http://www.bizjournals.com/cincinnati/news/2016/08/17/corporex-buys-nearly-3-acres-for-massive.html) It seems to be alive again. The state is also expanding the AA Highway/Route 9 (it is already about 1/4 done) through the Westside of Newport to increase economic development along that route. That explains why some of the public housing around there has been torn down. Its part of a plan, not just more parking lots
I would encourage you to stay engaged in the region - I would argue that the metro area has in many way's "turned over" from the glory days of the 50s-70s. Maisonette has a new tenant called Boca which is great. Orchids at Palm Court is a top restaurant in the entire Midwest if you ask me! (food in general in the area is amazing right now) Downtown is coming back slowly but surely, the Banks project is on phase 3, GE just moved over 1,00 employees to the riverfront and P&G is consolidating more of there people downtown on a regular basis. Over the Rhine of course is a story in and of itself, and it is pretty amazing what has happened there. And as a whole, both Cincinnati metro and Campbell County are growing (https://en.wikipedia.org/wiki/Cincinnati_metropoli...) especially with millennials and YP’s. All this to say, I clearly have a passion for the area and believe in its potential. Just trying to spread the love.
I will continue to look into the things you bring up, and I do appreciate the advice. One question though, it appears to me that for a buy-and-hold investor, inflation and fluctuating market demand are not all bad. Of course a rising tide lifts all boats, but generally if the value of your debt decreases while rents and the number of renters increase, that's not a bad thing? The duplex does not have a view, but it is in a very walkable neighborhood with good amenities: new restaurants, shops, police and fire and convenience stores within two blocks. Both units bring about $550 right now, and all utilities are separate and updated so tenants would pay those. I am hoping to add value by slowly renovating kitchens, adding coin laundry and other income generators. I just cant start with a top level property in my price range.