I've called an attorney as a witness, I've also had four that I recall crossing. All instances were totally fine - nothing bizarre, and two were even victims in cases. I think attorneys are often very careful not to say anything that gets them in trouble on the stand, since the effect of impeaching them or pointing out that they're being evasive/slimy/untrustworthy is pretty high - higher than a normal witness. You get a whole extra layer of questions that relate to their oaths and professional ethics and their should-know-better experience. Plus there can be sever ethical violations for the testifying attorney, should they lie. No one really wants to risk opening that box.
That said, one of the most entertaining crosses I've seen was when a defense attorney (friend of mine) ended her representation in a case, mid-trial, to be a witness in that same case. The issue wasn't the central charge, but an additional manufactured one of the defendant threatening the testifying officer in the hallway during a break in the trial. The officer basically lied on the stand. The defense attorney was the only witness to the alleged threat (besides the client who can't be forced to testify) so the judge allowed the withdrawal. (The judge really should have declared a mistrial.) Anyway, the second chair took over the trial, and the primary defense attorney (who had voir-dired the jury, and cross examined the officer in question) took the stand. What make it more odd and dramatic was that the prosecutor and this attorney really loathed each other. My friend more or less accused him of enabling a fraud on the court by not reigning the officer in during questioning, and/or not letting the defense and court know about the changed testimony, and/or not agreeing to a mistrial, and/or not taking her word over the officers that there was no threat. There was an hour of hot procedural issues before the trial resumed. So the actual questioning got pretty lively (snarky), with each party looking to get in digs on the other and open the scope of the questioning in ways that would be favorable to themselves. Also - this was done on the fly, so each party had to carefully pick their way though questioning (and answering) cold. No time to prepare or consult or even look up the law on what areas were or were not covered by A/C privilege in this situation. The defendant was ultimately acquitted. I'm pretty sure there were about a dozen hard wired appellate issues in that transcript though.
Later in my career, I listed a prosecutor as a defense rebuttal witness. This was a safe move since mid-trial the prosecutor had gone on the record to relay information the officer had presented to her which didn't match the officer's deposition. (And kudos to the prosecutor for doing so! I was actually proud of her, which tells you how closely some prosectors examine their cases and/or look the other way). That prosecutor's boss and the cop wanted to press forward, so I listed the prosecutor as a witness. After much wrangling between the State Attorney's office and the judge, the case was dismissed. I'm sure in no small part due to the embarrassment all the parties looked to suffer from if the prosecutor who picked the jury would testify that her lead witness was lying. I honestly don't know why they didn't instantly drop the case.
I also listed a sitting judge as a friendly defense witness. Again, case promptly dismissed. What junior prosecutor wants to cross a sitting judge who is going to say that the defendant did no wrong? There's no path of entry for questioning that does not become very very sticky.