Hi,
There is a lot of information on this forum, so I’d suggest using search first.
My migration was back in 2022, however there are a few known-good SSDs mentioned…
Don’t buy a huge SSD and load it up with media - you’ll just make HA backups slow and huge.
https://support.nabucasa.com/hc/en-us/articles/25549332241949-Adding-an-SSD-to-a-Yellow-with-an-existing-Home-Assistant-installation
A CM5 without NVME is cheaper, but makes future re-use a little harder.
If this helps, 
this post!