I was on the Code Blue team at my psych hospital, Keystone Kops indeed. For the *most* part our nurses are competent, it's more the residents (and sometimes attending psychiatrists) who want to do ALS when we are only BLS certified and have BLS supplies. There is a medical hospital across the street and we call 911 to transfer them.
The biggest calamity of errors I saw was a seizing patient (no known seizure disorder, no known withdraw issues) and the old school attending wanted us to put something in the patients mouth to keep him from biting his tongue, then wanted us to start an IV (which we don't even stock supplies for). Luckily myself and the other nurse were both confident and able to say no and that we were going to follow protocol, the fairly egotistical attending was trying to argue with us while the other nurse and I were rolling the patient on his side, getting suction set up, drawing up IM valium, directing the floor staff to manage the other patients who are starting to escalate, luckily one of my attendings then showed up to the code (it wasn't our unit). The old attending is still yelling
at us that we're being "insubordinate", my attending walks up, politely greets the yelling attending and says "Marshmallowstar, what do you need?" I said "An order to administer the valium we just drew up." She gives the order and we get the patient off to the medical hospital but jeez that other attending was quite a distraction and escalated the unit's patients and staff by his behaviors.
Also had a time when a not competent nurse thought a 10 year old boy was having a stroke, was panicking, giving a very poor report to the code team and was ready to send him out 911, however I was able to get out of the patient (not the nurse!) that he had just received his first dose of risperdal 20 minutes prior, never knew that IM benadryl was a cure for stroke
My best advice is to review your emergency policies, your crash cart, expected emergency med dosing and equipment and be the most educated you can be so you can be an advocate for the patient in the moment. Medical codes may not be your comfort zone but remember all your training, you went to nursing school just like the med surg nurses and have the knowledge, it's just making available in times of crisis. Sounds like you did a good job, know that med/surg nurses second guess themselves after codes, especially when a patient doesn't make it. There's no going back, if there's something you would do differently, remember that for next time and move forward.
Does your hospital/unit do debriefings following critical incidents? I've found them to be helpful to get support from peers and often multiple members of the staff are impacted.