Some great low cost first films are; Fujifilm C200, Fujifilm Supria 400, Kodak Ultramax 400 and Kodak Gold 200
Are you shooting on a sunny day? Then we recommend a 200ISO speed film. It's then just a question of whether you want a neutral colour pallet of C200 or the warmer colours of Kodak Gold 200.
If shooting on a lower light day, or indoors in a well lit room, you may want to get a 400ISO film. Fujifilm Superia's colour pallet favours green shadows and has an overall cooler temperature. Kodak Ultramax has a warmer pallet, favouring red shadows and soft darks.
Although every film has it's own unique colour pallet, keep in mind every part of the process will effect the end result of colours; from the lens, temperature of film, expiry date, how the film was stored, the development, the scanner used and the exposure.
Something you should also note is some compact point and shoots are only designed for a 24exp roll of film. All this means is that if you put a 36exp roll in them they may prematurely wind themselves off.