I am an engineer who transfers and restores movie film.
fps
I have transferred film that was shot at 12 fps (1928 film). At that speed you can actually see individual frames and there is no illusion of smooth motion. However, it is still enjoyable to watch. Here's an example:
If the frame rate is the standard sound film speed of 24 fps, you no longer see individual frames, but the motion is still not smooth.
However ...
It is not "worse" nor is it "better" than higher speeds.
This is the thing that is missed in many of the posts. Many shows and movies are still filmed at 24 fps, not because that was the way it was done when movie film was the only way to capture motion, but because it imparts a "once removed" feeling to the action. Put another way, it does not look like reality, and that is actually a really good thing for putting the viewer in the right state of mind to believe the fantasy that is being projected.
By the time you get to 60 fps (or 30 fps interlaced), the motion is fluid and that "once removed" feeling is gone. There is very little change you will perceive by going to higher frame rates.
Spatial Resolution
720x480 NTSC resolution on a 55" TV screen does not look crisp. 1920x1080 HD resolution looks really sharp.
But here's the thing: continuing to add pixels doesn't provide a better looking picture on that 55" TV. The reason is that the ability to resolve additional detail depends on the size of the screen and the viewing distance. For a 55" screen viewed at 10-15 feet, 4K video (4096 x 2160) won't provide you with the sense of a superior picture. You
might see a very, very small improvement, but in most cases you won't see a thing.
For a 55" TV screen, 4K is mostly a wasted effort.
If you go to a huge screen, or if you view at a really close distance, then you will see more detail. Also, 4K is a really good acquisition format because you crop in post and deliver in HD, and you can do many other tricks once you "have more pixels than you need." Always shoot in 4K, when you can, even if you plan to deliver in 1920x1080 HD.
Compression
This is the killer for most people. The quality and amount of compression can absolutely kill detail and introduce huge artifacts that are hard to ignore. It is really hard to find video sources that are not highly compressed. The compression in my
Mavic 2 Pro is not very well done, and is definitely an issue compared to the compression in most prosumer dedicated video cameras. Those cameras, of course, have virtually no weight limits compared to an aircraft, and can afford more CPU horsepower to do a better job on compression.
So, as to the answer to the OP's question:
24 fps works well if you want a "once removed" feeling to your video. It is an international standard that can be played anywhere.
25 fps is a European standard for video that grew out of their original PAL SD video standard. If you live in the US or if your distribution includes the USA, you should avoid this frame rate.
30 fps is the North American (and Japan) NTSC video standard. It is actually quite rare to have 30 fps progressive video, because most video is interlaced which gives you an effective 60 fps temporal feel. Since 30 fps does not give much more of a fluid feel compared to 24 fps, I would avoid this one as well. In this day and age, most people are probably better off not shooting 30 fps interlaced (sometimes called 60i) and I don't even know if the M2 Pro has this option. Instead, you should shoot 60 fps progressive (a.k.a. 60p).
So my advice is this: shoot 24 fps when you want cinematic, "once removed" feeling, and shoot 60 fps for everything else. Avoid all other frame rates.