There are a lot of cross over in tacticas however some not. Specific things like "tactical sequence" and other match rules can be a big no no in the real world. Also there are some things that are done in comp to save time that are not done on the street. That all said, There are things that the tier 1 military guys and LE learn from comp shooters such as speed, draw time, target trans, and so on. Its all knowing what tactics are applicable for comp vs street.
Ton of great instructors in the US. What state are you in. I train / teach all over and know a lot of great instructors. I recommend a good tuned up instructor that teaches real world tactics, not sand box, tactics from war. Shooting is shooting, correct but there is a lot more that is taught in a good class that is going to be geared at fighting in a urban US environment.