I'm more of a lance person, but when I get to use a firearm, I use the ones that fit the situation the best.
When I play on small, tight maps (like cracow) I take pistol or musketoon. When I play on a big, open field map I take the most accurate musket.
I don't have a favorite one, since firearms stats often change.