Brand wise I have mostly CMT. I like them better than Freud but I don't really dislike the Freud either. I have a few in others brands including Freud, Amana, Whiteside, MLCS, simply because it was the only brand I could find offering a specific bit.
Most used profiles?
1/4", 3/8" Rnd. Over (for edge breaking and really small round overs I usually use a sander)
Ditto for Beading
45 Chamfer (although I frequently just do this with a sander while sanding)
1/4, 3/8, 1/2 Cove
After those it is a pretty long list of about equal usage. Round Nose, rail and stile, straight, rabbeting, etc.
I do a wide range of work and frequently am matching old / existing profiles. So I have ended up with a pretty good size collection of bits that have only been used once or twice.
On the sander notes above I use a router if there are more than a couple pieces.