I've been looking at duplexes/triplex for months now. It has been a ride that is for sure. I agree that most duplexes are in not the greatest of areas/conditions/outdated but this also give you opportunity for forced appreciation and in some cases leverage in your negotiation to getting the price down. In the end its a numbers game and you should always make sure the numbers work for you. I don't know where you are looking but you may need to expand your area if you are willing/able to commute. I would say in my area with what I am looking for in my price range its about 1 out of every 30 is in and area I like and of those 8 out of 10 the numbers don't work. Just keep looking and try running different numbers/scenarios
ex: increasing your purchase price but also getting more rent to offset the cost
-lower down payment to help leave you money to renovate and force appreciation
Remember its a numbers game the more listings you see the higher your chances are of finding one. Hope this helps.