Do you know the specs of this laptop off hand? 2007 would place it in sort of a grey area between 32 bit and 64 bit CPUs. If it is 32-bit, you are likely going to have major issues and I would recommend using something else.
Even if it is a 64-bit CPU, the performance may not be amazing, and running modern browsers with anything less than, say, 4GB RAM could be an issue.
I would recommend something lightweight, such as Linux Mint with the XFCE Desktop Environment. You may need to get even more aggressive about finding something lightweight for something that old, though.
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.