Is
this your motherboard? Assuming so, the first thing I would do is ensure it's running the latest BIOS, which was only just released on 31/05/2022 and is version 7C84v1A.
You will definitely notice a massive improvement moving from a mechanical hard drive to an SSD, even a SATA one, let alone a faster M.2 drive. Personally, I'd buy an M.2 drive as they have faster transfer speeds, which can be handy when moving large files around. They are also slightly faster than SATA drives, but most people can't tell the difference between M.2 and SATA drives during normal use.
When you do get an M.2 drive, be sure to install it in the M2_1 slot on your motherboard to get the best performance out of the drive.
I personally like Samsung drives, they have always served me well. People like Western Digital drives too, but I've not installed one on my own machine, so can't comment.
Something to look for are TBW figures, these figures tell you how much data can be written to the drive over it's life.
My 500 GB Samsung 970 EVO Plus drive has a 300 TBW figure and I've given it a decent thrashing over the 3 years I've owned it. Samsung Magician tells me that 92 TB has been written to the drive through it's life, with CrsytalDiskInfo reporting 91% health - pretty good, in my opinion.