If you look closer, these aren't much different.
The pleasure of conversation comes from the exchange, the back-and-forth action. Both of these kinds of boring have the same problem, in that they prevent this exchange from happening. And when that exchange doesn't happen, people don't enjoy the conversation as much, which colors their impression of the other participants.
The chatty person who doesn't let others speak might enjoy hearing themselves talk but will find others quickly tire of just listening. The boring person who only wants to discuss subjects dear to him is similar, because he constrains the conversation such that others might not have anything to say. The quiet person who says little seems disinterested and unwilling to keep the conversation going, even though they may be listening intently and enjoying it.
These are just habits though, and they don't always have the same cause. Chatty people, for example, are often just anxious about being misunderstood, so they try to cram lots of details into what they say. Another person anxious about being misunderstood might simply not say much at all. I've found myself exhibiting both habits in different situations, and I suspect many others have too. Like many things with SA, it's normal to an extent but bad when it becomes habitual.
So then, if you're trying to have an enjoyable conversation, the goal should be to encourage the exchange above all. Your ability to keep the conversation going is what impresses upon people and gives them positive feelings about you. The content of what you say is important, but secondary.
There are no hard and fast rules on how to do this, but a little effort goes a long way. If you're speaking and getting a little long-winded, just wrap it up and let the other person speak instead of trying to say something more to hold their interest. Omit unimportant details from stories. When you're listening, smile, nod, and laugh when appropriate. Ask questions, especially if it seems like the person has a lot to say about the subject. People love talking about things that are important to them, and the more you can get them to talk about it, the better they feel, which makes them feel better about you. And when it seems like a conversation is "over", just let it end.