Masking tape would have taken a long time to melt/burn at the butt joint if the upper stage had ignited. It might have held onto the booster motor a bit too long (again, only if the upper stage had ignited), or burned away on one side and held a bit on the other and had a dangling booster for a split second or more.
"Magic Tape" is the 3M brand name for the translucent Mylar tape that does not destroy documents as it ages. It looks frosted but turns pretty clear when applied to an object. You can write on it with a ballpoint or other pen. It melts WAY fast and is not so good for taping together multi stage motors. You can use it, but it requires several wraps to hold the proper amount of time.
"Cellophane Tape" is common cheap tape. The kind that destroys documents with age as it turns a horrible yellow as it ages and the adhesive dries and cracks. it is great for short lived items like seaing gift wrap or multi-staging. You cannot write on it with a ballpoint pen. It is cheap, cheap, cheap. It actually holds staged motors together a tennsy weensie bit longer and even if you use two complete wraps it melts away at exactly the correct time: after upper stage ignition actually occurs. The tape and adhesive are strong enough that if the upper stage fails to ignite (because they are a tiny nozzled Estes B6 or C6 or C11 motor) the tape will remain intact and hold the motors and rocket together as they lawn dart. Big nozzles in the upper stage are the answer.
Did I mention that Quest motors have larger exposed propellant faces and with the MASSIVE extra smoke are PERFECT upper stage motors?