Hi Simon,
depends what you're looking for - I guess compact, lightweight and steady for longer exposures.
The next question is, would it be for a compact or a heavier SLR?
I've been using one of these Cullmann Magics for years, a very sturdy tripod:
http://www.cullmann.de/en/results/cat/magic.html The 2 great things about them
1.They fold flat and short
2.You can take out the central column, screw one of the telescopic legs on to it and you have a monopod which is a great solution for steady shooting in tight spaces.
Only one drawback - they cost almost 10 times as much as the Tesco offerings - but at least you get a tripod that'll last a lifetime.
They've been pretty popular over the years (mine is about 30 years old) so I wouldn't be surprised if there are some offered on the bay, so you might get one at a knock-down price.
Cheers from Teutonia