"People are often talkative when it comes to sports" sounds more correct to me. If there is no auxiliary verb, you put 'often' in front of the verb, unless the verb is 'be'. If the verb is 'be', you put 'often' after it. As to 'usually', it refers to experiences that are habitual or customary. The same condition applies to it, so you might want to say: 'People are usually talkative when it comes to sports'.