I usually just shoot medium or large if I am going to bother to use a tripod at all. As such, I use a fairly limited selection of 35mm films, but I use almost every film available in medium format. So, after using them all, my "educated" conclusion is: All the films out there by Kodak, Fuji, and Ilford are excellent. You can't go wrong with anything from these three companies. So, there really aren't any "good" or "bad" films period from any of these manufacturers...just films with certain characteristics that you must learn to decide whether they are good or bad for what you want the pix to look like.
When it comes to price, Fuji is usually the cheapest. Their medium format b/w film is priced very competitively.
I like Ilford's over all selection the best. Everything they make is available in medium format, which is nice.
I use Kodak simply because nothing looks quite like Tri-X and Plus-X.
For color, I love Fuji and Kodak, but for different things. For studio shooting, I prefer Kodak, as I think it just plain looks better in a subjective aesthetic sense.......until you use it in foul/low/mixed lighting, in which the Fuji just kills the Kodak, IMO. I also prefer Kodak's line, with an NC and VC available in both 100 and 400 speeds, plus Ektar, Ultra Color, etc. One exception to this general approach is that I absolutely love Fuji Reala. It is my most-used medium format color film for landscapes. I also think it is the best for products and still lifes. However, for people in "controlled" or "good" lighting, I almost always use Kodak for color neg.
So, basically, what I do for color neg is: Fuji for places and things, Kodak for people.
So, getting back the the gist of what I am saying: There is not a bad film made for your RZ by any one of the big three film companies. There are only films that are better suited for certain things.
One suggestion I definitely have: Shoot color neg. The "home lab" situation you describe almost demands it, and there is enough variety out there for you to get what you want, especially if you are scanning anyhow.
I can't tell you what to take to Mexico for you....but I can tell you for sure what I would take to feed my RZ kit (65, 110, 210) if I was going to Mexico for two weeks:
1. NPH/Pro 400H (120/220 available). I try to never be without this film on a trip, even though it is not the one that I use the most. It simply covers so many bases. It is just plain beautiful, fast enough to hand hold even in less-than-ideal light, and holds up to enlargement better than the 800 (which also does very well, BTW).
2. Reala (120 only available). As much as I can carry and/or have time to shoot. My general-purpose 100-speed color neg film. I usually use this unless I am looking for faster shutter speeds.
3. NPZ/Pro 800Z (120/220 available). For hand held use. Opens up a lot of interesting shooting possibilities, and simply looks amazing and unique.
I consider these three my must haves for color landscapes/travel in medium format.
I also generally bring transparency films. I always have T64 and Provia 400X for sure. I also usually bring a 100-speed Ektachrome of some sort (EPN, EPP, E100SW, E100G, etc.).