You do not want East Pointe or Roseville. Grosse Pointe is the only area on Lake St Clair worth moving to.
Unfortunately, after the whites left, they never stopped expanding outward. So some of the nicer areas are about 20-30 minutes away from the Detroit border. You could stay near Woodward and head north through Royal Oak, Birmingham, and Bloomfield Hills, which are very nice too.