

I am not aware of any SATA SSDs which use HMB, so I am not sure if it would work correctly through an adapter. I think the choice for 2.5" SSDs is generally between DRAM cache SSDs and ones with SLC caching, which are typically much cheaper. I think both are pretty much able to saturate the ~500MB/s bandwidth of a SATA III connection, but may run into issues with prolonged writes or when getting very close to full.
Looking on Newegg, for DRAM cache units, things like the Samsung 870 evo and Crucial MX500 cost ~$90 or so for the 1TB model.
SLC cache units like the Crucial BX500 or Team Group CX2 are much less, more like $50-60 USD. The Team Group one claims 800TBW endurance for the 1TB model. I do not know if I believe that, but generally speaking I have used their nvme drives before and have not had any fail on me, for what that small data point is worth.
The Samsung QVO drives are based on QLC NAND flash (Quad-Level Cell). It has lower write endurance than TLC (Triple-Level Cell) and they slow down to nearly hard drive speeds when close to full. Supposedly, the technology is lower cost, but when manufacturers charge effectively the same price or more for QLC as TLC drives, there is zero benefit for a consumer to buy them and they should probably be avoided.