Thanks for all the recommendations and viewpoints.
After weighing all opinions, we decided to stay at the airport Courtyard. This was to avoid carrying the bags on two buses + two metro trains just to see Prague at night. We'll leave Prague at night to another visit.
Thanks for all the great advice.