Webber/Camden & Victory, Lind-Bohannon on the "infamous" North Side. Many fine houses and neighborhoods overe here at good prices because the address has a "N" in front of it instead of a "S". N Mpls is bad, no doubt about it but a general rule of thumb is...if the house is higher than 40th St N it's ok.
E Nokomis/Wenona/Keywadin/Morris Park are actually in kind of a decline but I see a lot of value here. Big houses, good prices, nice neighboprhoods, close to the lake and falls. Drawback is airport noise.
(this is an interesting one)
You are asking a tricky question because none of us have crystal balls, and we are not legally allowed to "steer" you either to or away from a particular neighborhood. I have a gorgeous home listed over in the Linwood neighborhood on the W side of Lake Harriet and I am really liking that neigborhood. Now, as far as crime, it is our obligation to refer you to the local police department, who will gladly share the crime reports with you.
I have also felt that on the northern side, both Northeast and the Camden neighborhoods are both fabulous nice sized homes and great neighborhoods. I have bought and sold a lot of homes in NE and remember so many late summer nights driving through there and seeing all the little 8-11 year old kids playing and riding their bikes at dark. They all seemed so relaxed and safe. But that is my 3 cents worth.
But there are no bargains out there, really. If the neighborhood is safe, and the homes are large, you'll pay for it.
As for affordable housing, there are some wonderful areas out there. As far as "up and coming", Camden has some wonderful housing inventory at very affordable prices. NE Mpls is also a good mainstay. But, as long as I've been a REALTOR, the SW Mpls neighborhoods still hold the best market value of any area of Mpls.
I guess I'd need to know more about what would go in to your choices in order to advise you more thoroughly. You may contact me if you wish.