No, there’s no drama, no weird thing. It just works, just like any other CCS charger. Elon doesn’t come out and give a free hand-job while you wait or anything. About the only piece of excitement is the mildly confused looks from actual Tesla owners when you roll up.
Also the charging leads are really really short, if your charging port isn’t on a side it’s unlikely to reach. And if your port is on the “other” side to a Tesla it might be hard to park up if they’re nearly full as you might need to go into the wrong bay for the unit that’s free.