Has anyone flown to the Henry Ford Museum/Greenfield Village? What's the
closest airport and how did you get from airport to museum and what hotel
and so on.

I think you'll probably need a car from any of these...
The closest GA friendly airport (16sm NE) would be Detroit City Airport.
Other airports to consider would be:
- Ann Arbor (31sm W but 90% freeway driving)
- Willow Run (22sm W 50/50 freeway/surface street)

Also consider Oakland-Troy.