My preference is to shoot color slides when conditions allow. Kodachrome 64 is my favorite. I have used Fuji Velvia (ISO 50) with good results, though I agree with those who have reviewed this film stated its true speed seems to be about ISO 40. I have also used fair quantities of Kodak Elite 100, and Elite 200 (when pressed for speed). My results with these two have been spotty-some shots good, some shots not so good. I haven't figured out the reason for this yet. Kodachrome 200 seems to be a disaster (very grainy, reds appear violet if sun is present), and I advise staying away from it. I have had great results with one of the Fujichromes in ISO 100, though I can't recall which one it was. We are advised repeatedly in this forum that Provia 100 is the best, but I haven't tried it yet.
When using color print film, I prefer Kodak Gold 100. I don't know the difference between this and Royal Gold 100, though some folks here have a preference for the latter. Gold 200 seems to work well for me also. I don't usually shoot above ISO 200, but I have used a lot of Kodak MAX 800 in an industrial setting. I worked surprisingly well, and I was able to get many custom
8X19" prints from it that held together nicely. However, I used a roll of this stuff to shoot migrating geese and it was terrible. It was so grainy the sky looked like sandpaper.
In black and white I don't think you can do much better than the Iford Delta series. The ISO 100 is probably the best general use B&W film on the market. I had been a strong user of Kodak's T-MAX 100 and 400. It represented a big improvement grain-wise over previous B&W films. Still, I like the Ilford more. My use of B&W is declining. After all, I can make a B&W image from a color one with the click of the mouse. It is still possible to find Kodak Tri-X at many locations. This was the most popular film in the world in the 1960s. I always thought it did not privide me with good aircraft images due to grain. I think it was good in other settings, and was used by newspaper photographers a lot. But there is a huge difference in trying to get a fine B&W 8X10 print and looking at the same image on newsprint. There is also a big difference in looking at a fine print, and viewing it on the monitor. Something you may need to consider if you are going to use the image for purposes other than website viewing.
Hope this helps