Grew up there, but only occasionally return. Grew up in the city, and last lived in Southfield. Metro Detroit is very spread out, so a car is a must. Car insurance costs a fortune in Michigan.
If you like a more natural area, Oakland county, to me is the most scenic, and if I ever moved back, I'd settle there. Wooded, lakes, hilly in some areas, and lots of neighborhoods with homes on large lots. Southfield is diverse in landscape, wooded on the west edge, and corporate offices further east, and probably the geographic center of the metro area. A bit north, Birmingham, Bloomfield Hills area very nice high income area. The Grosse Pointes are on the east side, so a long drive if you have to regularly drive to other parts of the area, be prepared to put some miles on the car.
If you're into large older homes, built in the 20s, and 30's, when Detroit was really booming, the city has neighborhoods with a lots beautiful brick homes (tudors, greek revival, colonials, etc.), although some have fallen on hard times throughout the years. The architectural style of homes in some of those areas is wonderful. Indian Village, Boston-Edison, Palmer Woods, North Rosedale Park come to mind.
http://www.historicindianvillage.org/
https://www.historicbostonedison.org/
https://palmerwoods.org/
https://www.nrpca.org/
Edit: Forgot to mention Sherwood Forest, University District, and Greenacres.
https://www.sherwoodforestdetroit.org/
https://www.udca.info/
http://greenacreswoodward.org/