I have just discovered the ModeCalc program Graphical Mode Calculator from realtraps(Ethan Winer)
That's not a good one to use. IT only takes into account the axial modes, and completely ignores the tangentials and obliques. Better use these two:
http://www.bobgolds.com/Mode/RoomModes.htm
http://amroc.andymel.eu/
They give you the complete picture, plus a boatload of other extremely useful info.
(Q1) What is the standard or recommended size for the air cavity ?
How much isolation do you need, and what frequency do you need it at? An MSM wall is a tuned system. You tune it by varying the cavity depth, and the mass of the two leaves.
That said, you should never really go much less than about 4" depth, or you start needing huge amounts of mass on the leaves.
(Q2) Are there any issues with having large air cavities ?
Nope! The larger the better. Larger cavity = lower resonant frequency = good.
(Q3) Are there any issues with have different sized air cavities between the side walls, front and back walls and ceiling ?
As long as you adjust the mass on the leaves to compensate, there's no problem. Smaller gap, you need more mass.
(Q4) Is the myth about larger air cavities are better "bigger is better" true ?
It's not a myth: in this case the rumors are true: Size matters. Of course, there's a point where making the gap any bigger doesn't really help much more (diminishing returns), so a wall with a gap 20" wide would not perform a whole lot better than one with a 15" gap, but overall bigger gaps = better isolation. As long as you get the resonant frequency one octave lower than the lowest note you need to isolate, then making your gap much bigger probably isn't necessary.
I have read around some builds and recommendations of air cavity size of 25mm which is smaller than I originally expected.

That's only 1"!!!! Nope. Just nope. Uh huh. Way too small. Unless maybe you wanted to put an inch of lead sheeting on each side...
However, don't confuse the depth of the cavity with the gap between frames in a pair of stud framed leaves... it's not the same thing. Having a one inch gap (25mm) between two conventionally built 2x4 framed leaves, gives you a cavity depth ("air gap") of 8" (200mm)
Once I figure out the beam and stud sizes and how much Width, Length and Height a typical decoupled double stud wall ...
Careful with terminology! There are no beams in walls.... Beams run under walls, or under ceilings, but the are not arts of walls. Walls have sole plates, top plates, and studs. The studs are usually king studs, but if you have doors and windows then you also have jack studs and cripple studs, and headers. Ceilings don't have beams either: there might be beams that support the ceiling, but the ceiling itself has joists.
I understand that you are probably taking a break from the forum over the weekend.
I wish!

Just snowed under with projects right now....
I really don't have the luxury available of hiring a studio / acoustic designer,
How do you know? Have you asked one to quote you?
they are hard to find in rural Australia.
You don't need a designer from rural Australia. You just need a designer. He can be located physically pretty much any place in the world. I have designed a few studios for customers in Australia, but I haven't been back there in nearly 40 years! (even though I was born there.....) I very rarely get to visit the studios I design, and very rarely get to meet the people I design them for. That's the same for most studio designers, these days. With modern technology, it isn't necessary.
I just simply won't be able to provide you with accurate SPL readings,
The there's not much that anyone can do to design your place, including yourself! Trying to design a studio without know how much isolation you need, is sort of like trying to go on vacation without having a destination, or any way of getting there....
I probably couldn't really afford to contract a studio designer anyway.
How do you know? Did you ask a designer to quote? One important point: You will likely save money by hiring a designer. He will probably save you the cost of the mistakes you will make if you try to do it yourself unprepared, many times over...
If I was so worried about acoustics etc etc I would never get any music finished, im a musician at heart.
Let me flip that around and send it back at you, so you can see the flaw in your reasoning: "If I was so worried about music and instruments etc etc I would never get any studios designed! I'm an acoustician at heart."... Not sure if you see the silliness in that. As a studio designer, the most basic thing I am concerned about is NOT studio design, but rather music any instruments. That is the very reason I do what I do. If my most basic concern was not music and instruments, I wouldn't be much of a studio designer! Ditto for a musician who is not concerned about the acoustics of the rooms he plays in, and mixes in... Acoustics is the underlying principle of what music is all about.
I would really love to be able to contract someone like yourself to design something professionally over 6 months or whatever , but its not really a viable option.
How do you know? Did you ask a designer to quote?
- Stuart -