PNY doesn't manufacture the CS900 and I doubt Gigabyte makes theirs either. Many of these budget SATA drives belong to one of a handful of designs. I recently bought a 1TB PNY CS900 and it's the exact same drive as the Team Group CX2 I have. Same Phison S11 controller, PCB, and even casing. The only physical differences between them are the NAND and stickers.
That said, the PNY CS900 has 96-layer Kioxia/Toshiba TLC and generally outperformed the Team Group CX2, which has 96-layer Micron TLC. It also has a bigger pSLC cache, about 20GB vs ~7GB for the Team Group. That might be partially explained by the fact that the Team Group has less inherent overprovisioning, presenting 1024GB (vs 1000GB) to the user. Outside the pSLC cache, the PNY wrote ~81 MB/s vs ~71 MB/s for the Team Group.
I also tested a 512GB Silicon Power A55. The one I received had a SMI 2259XT controller, paired with 144-layer Intel QLC. It has an enormous pSLC cache, seemingly using the entirety of the free space, so ~125GB when empty. However, writes crashed as low as 6 MB/s once exhausted, though they did eventually average out to about 38 MB/s.
Of course, there's no guarantee that buying the same drive will get you the same components. Of the cheap drives I've recently played with, the PNY CS900 would be my choice. In the past, I've had good luck with similar drives using the Phison S11 controller and Kioxia NAND. I've had trouble with some drives that use SMI controllers (usually paired with Micron or Samsung NAND).
If possible, I'd spend the extra on a Crucial MX500. It's a much better grade drive, has DRAM, and will absolutely trounce any of these budget drives. Just don't inadvertently buy the BX500, which is an embarrassment to Crucial's name.