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.
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.
Sounds reasonable.
The Samsung 870 EVO should be comparable, if not even slightly better than the MX500 (1GB DRAM cache for the 870 vs 512MB for the MX500, and rated for 600TBW instead of 360TBW for the MX500). Samsung had a spate of failures with their 990 NVMe drives a while back, but aside from that they have a good reputation for reliability overall. I used one of the prior-generation 860 EVO drives in a laptop of mine for years and never had an issue.
Team Group is a decent budget brand in my book. Taiwanese-based memory seller who make both SSDs and RAM, even micro SD cards and flash drives. They have an actual product portfolio instead of just one or two models like the no-name drives. I have used their 4TB MP34 pcie gen 3 drives before with good success (now discontinued, but at one time they were one of the cheapest DRAM-cache NVMe drives available), and I have one of their MP44 gen 4 HMB drives in my current laptop.