When it comes to users there are three groups. Professionals, pro homeowners (DIY) and amateurs.
Likewise, there are three grades of tools. Pro, pro-budget and budget tools.
Brand name tools, like Milwaukee, Makita, DeWalt etc. are almost never worth it when comparing price to performance. Except for professionals, which get the best value out of it. Although they can also get away with pro-budget tools (typically the store brand).
Based on your question, I take it that you belong on the middle group. For power tools I always recommend Ridgid as I believe they offer stellar value. Their tools are great and the prices are really competitive (especially on sale) for what you get. Additionally, the lifetime warranty offers great peace of mind.
Other pro budget tools are also a great choice. Personally, I think its hard to compete with Ridgid.
The same goes for hand tools. Pro budget tools typically offer the best bang for you buck.