For weapons i find a lot of how bad I find certain guns depend on my mindstate. For years my favorite weapon has been and still is the Braton prime (not a big fan of the incarnon mode on it so I just use the base version the vast majority of the time). Was it a good gun to take into steel path before its incarnon, not really. That is part of the charm however, nuking entire rooms with aoe is fun, but sometime I want just me and grandpa Braton to shoot Grineer in the face one at a time like the old days. If anything I find I enjoy it slightly less now that the incarnon is buffing up the base stats. Maybe I should see how far I can push the mk1 version instead?
It sound like you're reaching burnout territory however in which case my recommendation is just take a break whenever you start playing as a obligation instead of just because it's fun. Come back either when a new update drops (in this case Kullervo is just around the corner), or you just feel like playing again.
There's a lot to do as a personal goal (personally i'm working on legend 1 and maxing out the helminth), but if you burn out from the grind getting there then that sort of ruins the point no?
Play something else for a bit, warframe will be there when you feel like doing space ninja stuff again.
I've gone through four different methods of tracking all of that. When I first started pushing mr, I used a excel spreadsheet with a ton of conditional formatting and autolookups. Eventually it started to get really laggy so I turned it into a sql database which worked fine but just like the excel sheet it was a pain to maintain as I had to go back through updates I'd skipped and add a bunch of stuff retroactively after breaks etc.
After getting tired of the database shenanigans I found this website which worked fine (still does). Now days I usually just use Alecaframe however. I don't really like overwolf, but the benefits outweigh the downsides especially after wfinfo started acting up on relic reward screens.
The biggest advantage of alecaframe is that you can see what part you still need to farm in the app without having to dig through the foundry which I find very helpful at least since I tend to forget what parts I miss. A small tip a lot of people don't know is also that you can just search for parts in the relic screen and you'll see all Relics with that part so you don't have to dig through to find out what you have.