Whats the best really for emergencies? Also with the cartridge can I use any tube? I know it sounds silly really but I always had in my mind you needed special tubes for the cartridges. I'm reading and so far I see I don't. For pumps which work the best? Thanks in advance

You don't need special tubes. Presta valves are the most common, but you can get adapters.
As for which is best; Well, the supply of atmospheric air is effectively infinite. CO2 carts are one-use only. So it depends on how many flats you're willing to deal with until you need to walk home.