Yes, any 35mm photo (not motion picture) film will fit in any 35mm photo (not motion picture) camera.
Please read more about the basics of how to purchase 35mm film:
http://www.flickr.com/groups/filmphotographer/discuss/72157627197810939/
If you want "funky colors," you needn't buy Lomo brand film, which is just repackaged film made from other companies and the price is marked up.
If you want your film to be red scale, buy any Kodak or Fuji C41 film, a film changing bag. Inside the changing bag, you can take the film out of its cans, reverse it and roll it back into the canister backwards.
If you want your film to be cross processed, just buy any Kodak or Fuji E6 film and have it processed at any mini lab in C41 chemistry.
If you want b&w, shoot b&w film. Kodak bw400cn and Ilford XP2 can be processed at 1 hour labs.
If you want expired film, buy some Kodak Ektar, Kodak Portra or Fuji Pro and let it sit on the dashboard of your car or somewhere else there is a lot of sun for a couple weeks or months.
If you want light leaks, open the back of your camera every once in a while, very briefly, through the roll.
If you want lots of grain, underexpose the film by two or more stops.
Lomography is nothing more than a company that capitalizes on experiments and accidents photographers have been doing and having for a hundred years. You just need to learn more about film in order to learn to do these things deliberately. In some cases, just buying Lomo film or their cameras will not even actually create these effects.
Have fun!
METAL AND MANUAL! FILM FOREVER!