Personally, I am a big fan of throwing weapons. Unfortunately, throwing knives are not nearly as effective as the Elder Scrolls Online trailer leads us to believe.
Throwing weapons can add a lot of gameplay possibilities. I, among many others I assume, am planning to do a bunch of different character builds. Some of those heavily rely on light armour and weaponry as well as the use of throwing weapons (Should they be implemented). I wouldn't mind being able to throw knives accurately and effectively though, as unrealistic as it may be. The throwing knives in Mount & Blade were effectively useless, seeing how they were incredibly inaccurate, didn't have a lot of range as well as the fact that they didn't deal a lot of damage against any decently armoured opponent. I'm not asking for Assassin's Creed level of throwing, but some throwing power and accuracy, combined with decent damage or very quick use would be very much appreciated by me.
Crossbows would be nice as well, along with throwing axes, rocks and slingshots. What I would really like to see, however, are spears or javelins. I can just imagine the satisfaction of readying a javelin, releasing and watching it just completely pierce a charging opponent, causing them to just get absolutely clotheslined by the impact of the spear. They could come in different sizes, too. Smaller javelins or war darts may not be as lethal as normal ones, but they can cripple an opponent very well. I imagine getting a 4 foot javelin to the thigh wouldn't be something you shrug off very easily.
Truthfully though, most throwing weapons weren't incredibly effective. That leaves the possible implementation as well as the functionality of the weapons up to the developers. Whether they, should they implement such weaponry, stick to the realistic use of them, or as I said, give them a bit of a buff, we'd have to see. It's definitely something that could add a new sense of risk to combat.