So, short summary: If you want THE BEST then Intel wins. If you want THE BEST VALUE FOR MONEY then AMD now has a strong contender again. (They used to be leaders there, but fell behind in the last few years.)
If you have an old computer with two cores, or four slow cores, and too little RAM, then any upgrade is going to feel great! Also, make sure you get a SSD for all your system and work files. Spinny disk for your video and music collection might be fine, but anything that’s in the boot/edit/compile/test cycle must be on SSD, or you’re wasting your life. That’s a more important performance improvement than getting the fastest CPU IMO.