The only good part of Raleigh is the Covington Pike / Stage area. We had a house on Kerwin get shot up twice.
If you are buying, I would never buy a house in those areas. Virtually all sales in Frayser are investor sales. Most sales in Raliegh are investor. If you can get into the Stage/Covington Pike area and you are buying, then you will be ok. I bought a foreclosure over there for $55,000 and it rented for $1,050. We are getting $995 a month rent. In my opinion, for a little more, you can find houses in Bartlett, which is much better then Raleigh.
If you are moving from one area to another and are not familiar with the area you are moving to, you are doing the right thing in research. Talk with local people, agents, businesses, and so forth.
Work, community, affordability, weather, all make a difference. If you own a property and selling to move would you be able to move back if it didn't work out? I know this first hand.