These days all i really ever play in Starcraft are maps that i have made myself
There are a few different scenario maps i played back in the day but i dont remember any of them. its been a long time.
The old maps i really enjoyed were the starship trooper maps. You would basically just defend your fort against wave after wave of zerg attacks, each one harder than the last. they took a lot of teamwork because usually each player would defend a section of the fortress wall with their units/structures.