As someone that was really big into CS 1.6 and CSS but did not bother at all with CSGO I can say that I've had the best time on de_train, so that map makes me very nostalgic. If we're talking about what's the best from a competitive POV though, I will have to say dust2.