clearstream
(He, Him)
I think what you are saying is that you do not agree with the designers' power ranking of items. Some items that you feel are powerful enough to need attunement, don't. Other items that you find weak in play, do. It is interesting, but I think you'll agree irrelevant, that you would characterise readings that agree with yours as "careful"Maybe you haven't carefully read the DMG...
So yeah, I think that there are quite a few attunement items in the DMG (and also in our game from the previous DM) that probably shouldn't be attunement items. As a DM, I could go through whichever ones I hand out and say "this does not require attunement" even though the DMG says that it does, but that's too much effort both in trying to determine the utility of every attunement item, and in keeping notes on which ones I modified and which ones I did not.
The game designers thought that a +1 through +3 weapons should not require attunement, but these are items that increase damage 60+% of the time and to a considerable amount in that 5% to 15% chance where the weapon would not have hit, and also against monsters with non-magic weapon type resistances. Personally, I think that +1 to +3 weapons, although rather boring, are very powerful items because they improve the power of the PC most of the time. The two weapon fighter can use two +3 weapons and be very powerful because of it, and still have 3 other attuned items. Other class concepts do not necessarily have this advantage.

In the case of uneven handling it is not going to be sufficient to just increase the number of permitted attunements. As some items will still use up that capacity that shouldn't, while others will not count against it but should. Of the replies to this thread I have read, I really felt that CapnZapp was thoughtful. It touched on something that Unwise echoes and that seems simply obvious once you reflect on it: at different times in different campaigns, the effective power level of an item will differ. Ergo, uneven handling is inevitable as it relates to perspective.
Given the inevitability of uneven handling due to the wide variety of perspectives, we would need a system that calibrates against perspective. This would be a matrix similar to that proposed by CapnZapp but further subdivided by your campaign magic level per the table in the DMG. Even then it wouldn't please everyone, but I think it could go a long way toward meeting your requirements. Thus a +1 sword could require attunement by a low-level character in a low magic campaign, but not otherwise. Unfortunately, an uneven handling objection can never be answered completely because for example I find +1 stat items powerful whereas you don't. A party's ability to pass around an item that ticks characters up to the next bonus makes a big difference in skill-use heavy campaigns like mine for many of the same reasons a +1 sword can make a big difference in combat-heavy campaigns (I'm not saying yours is of course, just that it could be a context in which a +1 sword could feel better than a +1 ST).