Generally I would recommend something slower than 400. However, for low light, nights, cloudy days and interiors, I love Fuji Superia 800. Great stuff, very lovely grain, nice colours with good saturation, and still kind to skin tones.
For sunny day landscapes, I LOVE Kodak Ektrachrome 100VS. Very similar is the Elitechrome 100. Under sunlight, both of these films explode with colour and are richly saturated. They hold a lot of detail, so the best scanning you can get will be needed. Or, pop the slides into a projector and get ready to be wowed.
I just picked up a roll of Kodak Ultra Color 100UC. Supposedly also a very nice saturated film, but this is negative (C41 processing.) Haven't tried it yet, it's been too cloudy in T.O. This might be a good choice for you if you don't have an E6 (slide) lab close by.
If you do any portraits, you can't go wrong with either Kodak Portra 160 or 400. Now THAT is a look you can't easily get in digital. The highlight handling and the skintones are amazing.
For black and white, I don't think you need to spend much to get good results. I like grain, so 400 speed is good. I can still find good deals on AGFA Silvertone 400 (usually $2 a roll.) For finer grain and richer blacks, I like Ilford's Delta 100. I also have a roll of Pan-F to try -- 50 ASA, really fine grain. The amazing thing is Ilford doesn't charge an arm and leg. Their B&W films are a bargain for such a specialized product.
Let us know what you try and what you like!
Samples: Fuji 800, Ektachrome 100VS, Delta 100, Elite Chrome 100
Last edited by filmamigo; 10-23-2015 at 07:22 AM.