It depends on what and where you are going to use a tripod. For studio work a good solid heavy tripod such as the Manfrotto 055xprob is about as solid a rock tripod you can get. If for travelling about I have been looking at the Manfrotto Befree travel tripod range at around £118.
A couple of things to consider. There is the question of pay load a tripod can take and how steady fully extended. Shutter slap in a flimsy fully extended tripod could produce camera shake to some degree. I have a monopod which does take the camera/lens weight off having to hold them but don't use a head on it although as Robert says it makes it easier to adjust.
Just one other thing weigh your camera and lens ( I use wifes kitchen scales

) so you know what payload it is and then allow for a heavier lens for future use. Nothing worse than having a tripod with a head that drops down because what is on top is too heavy. That is unless you like photographing the ground