Above Weber State Univ on the mountain is a beautiful area with amazing houses (500K-2mill). The other poster is right though, that some parts are ghetto - just like any place really.
If I had the ability to move anywhere, I'd choose N. Ogden, above Weber State, Pleasant View, or even south near Layton/Bountiful. - You'd be commuting against traffic, and you'd be that much closer to SLC which is an awesome city.