The name does imply the reputation, and my first 2 tripods were Manfrottos. I still have one today, buy sold of the other one and got a Sirui carbon fibre tripod. You can go down to TK Photo to check out their range of CF tripods. I find them very well made for the price that you pay. If you don't like them, TK also as Gitzo tripods. I remember also seeing them sell a Manfrotto 190CX3 at $298.
Bear in mind the local mentality of getting the newest gadgets. I dare to say a good share of those offering the tripod just want the feeling of getting something new rather than having a real need for it. Similar to cameras. We see so many questions here about 'upgrading cameras' where it is obvious that the owner just don't understand how to utilize the current one and hopes the new one will improve his images by some "magic of new technology".
while what octarine says is true, you do get what you pay for with tripods.
so consider carefully what your budget is, if you can afford a manfrotto and you know that you will use a tripod seriously... then why not go for it.
just , please, don't buy the manfrotto, and then worship it at home on an altar... i know many people who treat their tripods like they are made of tofu. what's the point of buying a tripod to be a slave to it, when it is just a tool for taking photos?
Yeap i get that. Although i too think that manfrotto is a good brand of tripod to have, but i also have enough budget for it and i know what it can do to help me get better photos. The tripod i have now is the one that canon gave me when i got my cam at the IT fair so i thought this upgrade is worthy of.