If a highly authentic close-up shot is required for some reason, then there's an edit away from the wide shot anyway and it's easy to swap in the arm of a stunt person getting a legit poke with a syringe where the needle has no opening and the liquid goes into the plunger when it's pushed. Alternatively, for the close-up just swap in the arm of a diabetic person who needs to inject insulin daily anyway. Any serious shoot is going to have an EMT or RN on set to do the deed.
As is often the case with "movie magic", don't overthink things. When you control camera framing, editing, lighting, rigging, etc many times a cheap, fast and easy way to get the shot can be figured out.