I'd choose between two areas.
One is around Lions Dive since it's pretty touristy there - not in a bad way. Mambo Beach Club is staggering distance away and they've recently added Mambo Blvd which is more shops/restaurants. Also the beach bar at Lions Dive had a decent crowd one afternoon. Hemingway there advertised a band some nights.
We never got there but Wet and Wild Beach Club is a little farther east afaik.
It's also about 5mins south of downtown. If you like Jazz clubs - there's one at the Avila hotel on the way some nights.
Also when we were there the weekend dance clubs were in Salinja which is a few minutes east near the harbor. I think they move around though.
The other area would be Piscadera Bay although it's quieter. We rented a duplex condo for a few days at Piscadera Bay Resort - older but full amenities.
From there you can walk to Pirates Bay beach club - they'll have music later in the week. There's a little casino at the Hilton across the street and they have a beach bar. fyi there's a nightclub at the Floris Suites also - it's gay.
It's generally a really quiet area at night - there's a rarely used convention center there.
About 5mins south is the Rif Fort/Renaissance Mall complex - there's some restaurants there - I dont know about clubs though. At the Reniassance resort is the largest casino on Curacao - it's the size of one you'd see n Reno.
It's also possible to walk across the Swinging Bridge there to the old downtown.It did not seem very active at night but we were only there two weeknights to eat.
Driving south towards town on the interior road - the one that goes over the bridge - we passed a club that nightly had loud music and a crowded parking lot - I didn't get the name.
You will find much more nightlife there than Bonaire.
Curacao's Nightlife - Bars Dancings