I won't talk about cost but I've got a 10lb tank. Here is what I use it on:
235/85/16 tires, usually air up from 20 psi to 30 psi
34x9.5x15 Super Swamper TSLs. Air up from 8~10 to 30~35 psi
The 10lb tank works very well for this. Also you will be surprised how heavy a 10lb tank is. If I wheel once a month on the TSLs, I can expect to refill my bottle twice a year. Overall I really like it. Make sure to get one that shows overall tank pressure. I think the tank pressure starts at like, 2000 psi. When it gets to 500, you've basically got enough for one more round of tire fill ups.
I got my tank filled up last time at a paintball place. After that I had serious freezing issues. On my big tires and without the crappy tank fill up, I would get some freezing issues toward the end. My tank + ratchet strap+bottle jack has re-seated a number of beats on the trail. Very quickly and fairly safe as well.
But really, compared to having an air compressor or "I'll just run up to the gas station" the C02 tank owns all. Very quick and quiet.
Its also nice when the g/f calls, "OH MY GOD I'M ON THE SIDE OF THE ROAD MY TIRES ARE FLAT I DON'T KNOW WHAT TO DO AAAAAAAAAAAAAHHHHHHHHHHHHH" and gives me....that. Grab the toolbag, plug kit (safety seal plug kits brings so much win), torque wrench, couple blocks of wood, floor jack, battery powered LED light bar, and my C02 tank. Roll out there and sort it.
Having compressed air to blow off crap for field fixes is very nice as well.
Cons. Everyone wants to borrow your tank. Then you get it back, and all your C02 is gone. Way to prevent this: bury the tank in the back under all your crap with just the hose sticking out. Then you are like, "Sorry dude my hose is too short. Can't reach your truck". I know this sounds douchetacular but when 5 guys want to use your 10lb tank to air up their 44" tires...you don't have any left to air up your own tires!
As mentioned, when the main tank hits 500 psi, you are pretty much done. So just keep an eye out and refill it when needed. A lot of time they will only charge you by the lb. So if you only need 5 lbs to fill your half full bottle, then you only pay for what you take.
Other Con, finding a place to refill the tank. Like I said, I found a paintball place and the price was pretty good but they have a crappy product. Any welding shop can help you, but either you gotta do exchange (I would recommend this, then getting more C02 isn't an issue) or leave the tank with them. It really sucks to leave my beautifully painted aluminum tank with a bunch of guys who are used to not caring. I know its just a tank but this is why we can't have nice things.
The plastic coily hose that came with mine exploded. That SUCKED. I recommend carrying a small double ended barb fitting and some hose clamps along with your duct tape. If yours explodes, then you can do a field repair. Its a cheap and compact repair kit that will save your bacon.
The way my tank is "mounted" the regulator knob sometimes gets bumped. So I set it to 100 psi and taped it down. Problem solved.
The handle thing is CRUCIAL. Don't cheap out there.
Overall I'm very impressed with my tank. Seems like on the trail people cobble together an engine driven compressor and it never works (mind you, I live in the South so redneck cobbled together crap is common). Or a cheap walmart air compressor is bought that overheats after filling one tire 5 psi short of what the guy wanted. In comparison, the C02 tank just works.