Which audio interface did NOT work very well with SONAR?

First, only interfaces that might cause issues will be a low end interface with crappy drivers. 
Most interfaces under $400 do not have stellar drivers they will have things like hidden buffers which make it impossible to reach super low latency. Nothing wrong with these if low RTL is not needed.  
It's pretty obvious which brands have the best drivers. When this question is asked 90% of the answers = RME and MOTU. 
So that sort of narrows down the playing field right there if RTL and solid drivers are your priority. There are many great choices from those 2 brands, just pick the one that has all the features you need.  
If you find the price to high then I guess you'll have to go for second best such as Tascam and Focusrite. 
 
And second before shopping sit down and make a check list of what features you need, for now and for the near future. Here's a handy dandy check list of common features; 
 
http://www.cactusmusic.ca/Docs/Johns%20Audio%20Interface%20blurb.rtf
 
PS all these threads you've started really belong in Hardware sub forum where you'll find dozens of similar threads and all the same answers. 
 
Johns Interface shopping list: 
 
What kind of connectivity do you require? and how many of each.
These are some of the options:
XLR, 1/4",  Combi jacks,  RCA, ¼” line level, ¼” Instrument level ,MIDI, SPDIF, ADAT,MADI and others. 
How many ins and outs do you think you'll need now and in the future?
Are they accessible?  Front or rear panel?
Are all ¼” jacks Balanced?  
Is there a true stereo pair? Some don’t have a matched set of inputs.
Pre Amps will fall under the “you get what you pay for”  rule, but check out the reviews anyhow.
A/D convertors will also fall under the same rule and generally all are good these days. 
Are there peak level meters or just a little LED for each input?
Are there channel Insert jacks?
Are there separate controls for Monitor level and headphone level?
Is there a blend control for mixing Source with Computer ( DAW) ?
How many Headphone jacks? A level for each?
Are the input pads or line / Instrument toggle switches on the front, back or software controlled?
Is it a metal box or cheap plastic? Is it light and portable or large and bulky, Rack mountable?
Does it have an on / off switch?
Does it use Buss power or a power supply? Buss power can have issues with noise and Phantom power. Look for at least an optional power supply.  
Does it have DSP effects built in?
Does it use a GUI mixer? Having a software (GUI) mixer adds more options.
Can it be used as stand alone? Some interfaces are also handy as a small mixer.
Now we even have remote Tablet control for live studio and In Ear monitoring. 
Some interfaces are full blown live mixers. 
What are the Round Trip Latency (RTL) specs? Do you need low RTL for real time processing?
Do you plan on using Guitar sims? 
Low RTL is going to be at a higher price point. A $200-$400 interface will have hidden buffers etc.
Zero Latency monitoring is not the same as RTL. All interfaces have some latency.
Zero latency is just marketing hype for monitoring directly from the interface.
And most important of all, Does it have top notch drivers for your OS. 
What is the word on support from the company?
Does it come with free software, An LE version of a  DAW you would like to try?
 
Everyone will recommend the interface they have chosen, that doesn't mean it is the right one for you.