You seem to ask different, extremely broad, questions in your title and your text. If you would ask the question clearly on the TBB forum, at least there you should get some expert opinions on the merits of TBB. I'm guessing you mean to restrict your development to Visual Studio for Windows, in which case the scope for optimization of TBB may be better than for the others, not that people always do multi-core development in the interest of performance.
Whatare the best containers for multi-core parallel development. MFC CObect based containers such as CArray<>, TBB containers, or STL containers.
The best (wrt performance and scalability) containers for multi-core parallel development are always containers designed for particular context. Such containers can take into consideration read/write ratio, needed operations, number of threads, size of objects etc.