My Bernina is not thread picky. It has sewn beautifully with every thread I have ever put in it. I used Connecting Threads Essential most for my cotton threads. It is linty, but my experience is almost all cotton threads are.
I also like Aurifil, but it is very expensive.