I personally think that if you're not planning to use your tripod often, a cheapo one like those you could get from Carrefour, or 2nd hand through B&S here or Yahoo auctions would suffice. These tripods are usually more than enough to hold compact cameras, though they may be less "agile", or not as tall as the higher ends one.
Even though the most sensible advice would probably be to get the best tripod that you could afford (since it's one of those item that you'll least want to change if you got a good one in the first place), tripods to a lot of people are simply white elephant. Seriously, a lot of people won't even bother to bring their tripods out most of the time, relying on their proficiency to hand hold the cameras under well-lited condition. Most see the tripod, not as an essential part of photography, but more like a accessory needed only under special circumstances, like low-light (night photography), sports or landscape. That's fine really... and if you're having the similar line of thought regarding landscape, then would it really be wise to invest so much to get a high end tripod?
FYI, my camera is literally welded to my tripod.