what is the best transport from hongqiao airport to Shanghai downtown at mid-night?

Well, upon landing, you can take Night Shuttle Bus at the Gate No.1, Terminal 2. It will take you to Jingan Temple, People's Square, Lujiazui Area. The operating hours are from 22:30 to 45 mins after the last flight arrival.

In addition, taking a taxi is a good choice for you.