Compared to how stealth-based characters are still forced to fight dragons head on in Skyrim, I think Warriors got the better end of the bargain.
You are not roleplaying non-stealth characters, you just don't want to have the disadvantage of a warrior specialist. You get to kill things quicker and survive longer, so you have to sacrifice something in exchange for that.
In general the way a pure warrior get around the problem of a locked door is just outright kill whoever had the key.
(You might have noticed that it is how you finish the Oblivion final Fighter's Guild Quest. The Blackwood Company doors are unpickable, so you had to kill everyone for the keys. This is intentionally trying to suit a pure warrior player.)
It should be sufficient to get you through most quests. You would likely miss out on miscellaneous treasure, but as I say that's the price you pay in being more deadly in combat. I am not going to feel sorry for you that your character is stronger and tougher than mine.
You seem to have a great deal of emotional investment in the notion of what might or might not be fair for one or another character, and it appears that it's that that's driving your views on this matter, rather than any consideration of gameplay or roleplaying or verisimilitude.
Unless we presume that Nirnian locks are made out of some sort of indestructible superalloy, then the notion that those locks cannot be overcome through the application of physical force is nothing more than an arbitrary contrivance. It has nothing at all to do with roleplaying, and in fact is contrary to one of the fundamental aspects of roleplaying - internal consistency. It instead serves only as a sop to those who think that some sort of "fairness" should be imposed on the game.
Here's the issue as I see it - Nirnian locks are certainly made of materials that could be damaged or destroyed. Therefore Nirnian locks could be damaged or destroyed. Therefore an application of sufficient force should be able to damage or destroy them. And that's really that.