I think your perception of range is too dependent on position and not dependent enough on the player, and your own timing. In general I don't think there's anything wrong with the ranges you've assigned, but the approach can't be so formulaic.
Ultimately, you want to look at the big picture and think "how do I get the most value in a situation."
Here's two examples - TAG UTG raises 4xBB. You have:
Scenario A: That's a fold most of the time. Like 90% of the time. You need 1:2 and you're paying 1:1.5 . -EV. Your implied odds
: not so good. Gonna be hard to get value with obvious straights and flushes on the board, and the occasional reverse odds on the flush are pretty crushing.
Scenario B: That's a fold or a call-or-raise 50/50. 44 is really not much worse than 99 except for the counterfeit possibilities. Against the majority of villain's range we're slightly ahead, and against the villain's range that we're vastly behind we still have implied odds from set mining. What matters here are: a) how big is the villain's stack size (is it worth it) and how call-stationy is he (can we get it if we hit?). Also, will the big blind or small blind be coming along? Cause 44 is decent heads up but not so good multi-way.
All this stuff sums together into what folks call "spots." Finding a good spot to fold, call, or raise is the combination of all possibilities - your cards, their ranges, their tendencies, your image, dynamics between players, etc.
In the right context, "mistakes" can be correct plays... like 3-betting A7s pre flop to an UTG raiser from UTG +1. That's a terrible play unless: your UTG is tight-ish, you are tight, your UTG knows you know he's tight-ish and you know he knows you play tight, the rest of the table is likely to fold, and you are willing to give up the hand if the flop gets weird. Flop came KQJ, two hearts, UTG checks to me, and here, conventional wisdom would be to c-bet but that's a really bad spot for that. Which is where I ****ed up the hand. I ended up winning it but I ended up going in for the whole stack with only 44% equity in the pot which isn't a good thing.