La Cigale Hotel (located center of Doha)- 20 mins to
the airport

Ramada (center of doha) -15 to 20mins to the airport

Marriott Hotel - (near the airport) 5 mins drive

Depends of what type of a visitor are you. If you are a tourist then prepreferrable stay either in Remada or La Cigale but if you are a business traveller then it is more convenient for you to stay in Marriott...

Nightlife:
Since you are a single guy best night out is at Marriott they have best lounge there and the crowd is more on high class people compared in Ramada....

Ramada is nice too but the crowds is for everyone..

Intercon Hotel they have La Paloma nice bar too...