Can a pretty nurse inserting a Foley catheter cause an erection?

Yes. It happens often with patients. Nurses are aware of this and it's usually not a problem since it's not usually voluntary.