Spoiler - you may not like my answer
You are asking about pros and cons in a kind of generic way. My point of view is that the relationship you build with an instrument relies on three aspects, namely the sound, the interface and the possibilities it offers. I personally consider those as -almost- equivalent, but the priority order is that one. I would advise to evaluate the "pros" and "cons" on each aspect independently.
The easy part is the possibilities. According to you
needs, you are likely to know what you absolutely want to see on an instrument: "I cannot do without presets because I play live and need to find the exact same sound each time". However, on top of those
must-have functionalities, you can be appealed by
nice-to-have functionalities: "I do not need a sequencer, but it would be damn fun".
The interface: I feel this is an underrated aspect of things. Honestly, I sometimes like an instrument because I just click with it even if the sound does not fit 100% my taste. That's a very frustrating situation, Hehe, much more than an instrument that sounds perfect to my ears but has a poor interface.
The sound: "les goûts et les couleurs" as French say

IOW it is more difficult to speak about that in formal terms, it's a matter of taste.
Now, you can ask yourself about those three aspects and get a rational answer. Of course, you can also keep an instrument for other reasons, I'm thinking about sentimental value.
Back to the sound. On this aspect, the "which Moog should I get" question has come many times here and there. My typical answer is that it depends on who asks it.
If you're willing to get your first Moog in order to add that sonic colour to your synth park, you already know what you are looking for in terms of sound (i.e., you're not trying to decide whether to get a Moog or another brand synth). I think any model is likely to suit you provided the interface and possibilities meet your needs.
If you already have played several Moog synths, you may -or may not- know the slight sonic differences between the different models. So, you may be looking for the very same sound but a different feature set/interface or for something sounding just a bit different but still in the family. Now that's very hard to say for any fellow forum member because we are talking about very
Here is an example.
I've been playing a Little Phatty for 10 years now. When Moog Music announced the Sub Phatty, I was very excited to get
that sound with a one-knob-per-function interface. A friend of mine bought a Sub Phatty and I was finally disappointed: it did not sound the same, I found the oscillators a bit to clean/steady and there was something with the filter. I tried to A/B compare the LP and the Sub, I could reproduce the same sound everytime, but there was something very subtly different in the way the knobs interacted with the synth.
When the Sub37 was announced, I was even more excited (2 octaves are a bit short for me): the feature set was amazing. But I was disappointed all the same by the sound.
My point is: most of the musicians looking for a compact Moog synth with presets as their first Moog today would most probably choose a Sub Phatty or a Sub(sequent) 37 over a Little Phatty as they "sound the same but offer more". But to me, they do not sound the same.