Will this actually work on my 2007 xkr, is it a matter of just plugging in and streaming via the adapter from my phone

Yes, this works...but only as well as the FM signal allows. I have this exact adapter and find that it works pretty well...most of the time. It does--just barely-- fit below the cover for the ashtray area, so you can actually close the sliding lid while using the Roidmi.