Some Supernova weren't meant to be super strong or impressive. Others quite honestly were and some weren't even pushed to their limits.
I'm a Hawkins fans and hoped for a tougher fight that went past the use of hostages but ultimately that's how Hawkins fights. He simply doesn't have what it takes to make it far in the New World without bending the knee begrudgingly. Killer vs Hawkins simply displayed that the rooftop 5 are just different and they're the leaders of the New Generation. Killer took some Big Mom attacks, still kept going then decimated Hawkins when his dolls were out of the picture (still a tough fight since all's fair in a battle between pirates).
For Killer, it was great, he was only fatigued/injured because his captain was a hostage though Oda could've made Hawkins put up more of a fight and display impressive stuff with his Straw-Man and cards, in my opinion to make both look better (Hawkins by showing he's a capable fighter past just his title as a Supernova and Killer for beating him relatively easily).
Luffy, Zoro and Law's performances speak for themselves. Apoo was definitely the one that impressed me most since he's still up after all he's taken. Perhaps someone will put him down or he'll make it through the whole raid with his resilience.
Kid didn't meet some people's expectations but honestly overpowering then later outspeeding a Yonko, sending her flying with repel, attracting her to a wall with such force that she can't simply push it away and drawing blood quite often then pinning her to the ground, forcing her to steal souls, only to bust her through the island floors and have her eyes turn white is pretty impressive.
Kid tanked plenty of hits from her and managed to evade plenty of others. Mama Raid (while Kid had head injuries from Hawkins' doll), physical hits, Ikkoku Sovereignity, Fulgora, he handled all of these in some way. He outsped her to land assign and Damned Punk sent her white-eyed through the floors after she tried taking fodder souls mid-attack but was prevented (by Law). I know the guy didn't have an attack that caused wide-spread destruction but drawing blood from Big Mom is already something plenty of characters can't do, let alone pinning her to the ground then sending her white-eyed to the basement. Kid should've had an attack that did more environmental damage but he was still impressive in my opinion. Easily top 4 regardless of how you twist performances.
As for Drake (and I'm still a big fan and hoping for better treatment), the only hype he had was being a Supernova, being a Flying Six and being a Captain for Sword. Featwise, he disappointed since Oda used him as a hype-tool for CP-0 instead of finishing his bout with Apoo (even if he got up now and finished, it wouldn't redeem him but it'd be better than being KO'd for the rest of the raid). Drake's a spy, he wasn't going to be a rooftop Supernova so that was simply expecting too much but Oda did him a disservice by not giving him notable feats despite being present all raid.
Only ones that truly disappointed me were Hawkins and Drake. Kid didn't quite meet expectations but he did his part.