Anyone with any experience using the Roland Cakewalk A-300PRO?  I was never able to get the ACT to work quite well.

I had a similar Roland/Edirol and had the same experience as you. Mine never go it's ACT together either.

Would have loved to get my Edirol to work with Mac OS Yosemite but Roland stopped updating their drivers.

I use it with Win8.1, but the Samson Graphite 49 is worth looking into.  It works fine with SONAR in Mackie mode.  I haven't tried ACT with it.  Great no-frills keyboard/controller for $180.  It's worth a look anyway
 

 
 

I picked up a Code 49. What's the best way to integrate it with Sonar Platinum so the transport buttons and faders work? 
 

Great - I am sure you will be able to figure it out.  I am still stuck with the Cakewalk A-300PRO and I still cannot get ACT to work as it is described on the net...... I must be doing something terribly wrong!  Duh!

I have a CME UF8 from what seems years ago. Since going to Win 10 and Splat I haven't even tried it so I have no idea if it even works as it had a proprietary driver for the controls on it. It wasn't a bad wooden weighted 88 nite keyboard.

I also have a Korg DS-8 from the mid '80's.

Before tackling the M-audio Code 49,  i blew the dust off my old m-audio KeyRig 25 as a warm up. 
 

 

 
Class compliant so no special drivers needed.  All the original "Rig" software it came with is useless on windows 10.  I used Sonar's Generic surface to manually program the dials and buttons in a strip parameter configuration (one strip, knobs controlling volume, pan, send level, etc and buttons controlling mute, solo, arm, write enable as well as global transport play, stop, RTZ and record).  Then used ACT learn to set the master fader controller to master volume.  The WAI shows green on the active strip and I setup two remaining buttons for shifting one strip left or right to move between strips.  Having good fun with it.  Although for a midi track i cloned to thicken,  some of the parameters such as Solo button toggle both the original track as well as the cloned track, others do not. Assuming for now that's a Sonar "feature" ;).  Through this process i also figured out how to configure a pre-set with knobs/buttons working multiple tracks (in banks or 4 or 8) for mixing. 
 
Was hoping to plug-and-play the Code 49 in Mackie mode but seeing on other forums that's not going well.  Code 49 stacks several functions on one button and the button color can change based on the toggle sequence.  Arm, mute, solo, etc. Looks like i need to read a manual... Not sure when i'll have time to tinker.  Sometimes plug-n-play is darn convenient.