Paste wax traditionally contains more carnauba wax, which gives your car a "wetter" look. MSW is a sealant which is synthetic and not a wax per se. Buttery wax contains carnauba, but to keep it in liquid form, the concentration of carnauba must be low (carnauba is rock hard and MUST be diluted/thinned in order for it to spread).
The definition of "shine" is a vague one at best. It matters more to the individual than it does to general public. Here's why:
Carnauba-based car waxes add an element of depth and warmth to a car. Really stands out on darker colors, making the paint look "wet" and deep. Traditionally, durability has been a problem. (Good for 6-8 weeks)
Polymer paint sealants create brilliance and sparkle. Better for the lighter colors, and when durability is more important. Some have said the sealants, while reflecting light (the "shine" part) they tend to look sterile and without "feeling", but can last 4-6 months.
The best way to fix these inherent shortcomings, and to get the best of both wolds, is to apply the MSW first, wait 12 hours or so, then apply the wax in either the liquid or paste form. (I prefer the deep wet look myself, so I have used paste wax exclusively- more carnauba)
HTH