depends on what your current motherboard is capable of, if it can support an NVMe drive, definitely get one. its lightning fast. if it can only support sata connections, then definitely still get a sata ssd.
either way its gonna be a huge upgrade in terms of loading, but i advise getting at least a 1tb ssd because these days games are massive, and if you want to benefit from loading times from any games you play currently, you need the space to do so :).