Ok before you hardcoe fans freak out, I'm not talking about having something like a G36 or AK-47. I think an old kind of Flintlock long barrel rifle and or pistol wouldn't seem so out of place in TES. You would only have one shot so it would be only useful for either hunting or saving your life as a last resort if some powerful enemy was about to kill you.
Plus the reload animation could be realistic were you would have to have it go through all the steps of what it takes to reload a real flintlock weapon. And ammo would be limited, like you could only carry 10 or so bullets at a time.
It could make for some cool bonus missions and dlc as well. Lets say you had to find the materials for the weapon first then you would have to have a blacksmith make it for you and the same steps for getting ammo too. Also like a real flintock it would be useless in the rain or under water, and it could have random misfires at any given time. And they would degrade with each fire loosing a little bit of power and accuracy after each successive shot, until after about 10 shots it would break beyond repair. The only way to get another one would to be to find the materials again and pay to have one made again. I'm sure many of you think this is blasphemy but I would love to use a weapon like this in the TES world.
http://www.flaminharry.com/PageMill_Images/ampics/amcover%20shotW.jpg
http://www.armchairgunshow.com/ot53-pix/ma-twst-all.jpg
have a little time to think on what you said

TES is in a medieval setting so it would be as out of place as a dinosaur in a game set in a modern environment, please riddle me this did they have flint lock weaponry in the 9th - 15th century? no they did not

Flintlock weapons were introduced in the 17th Century so it would be out of place by about 300 years, this is not a rant and i am not intending to flame you dude even if it seems that way don't take it too seriously please