True, the original DIY was with a CK3000 and CTPPAR007. New models have since been released and it is possible to use the Mki9200 in the E46. The advantage here is that the Mki9200 has media streaming via hard wired aux / iPhone / iPod connectors as well as A2DP bluetooth. It's quite an impressive package for a couple of hundred dollars.
Retrofit versus new head unit will come down to personal choice and what look you want to have in your cabin. Many people prefer to stick to the factory look and add in 'hidden' devices whilst others are not so fussed and prefer function over form.
That said, there are some head units that have close to factory orange glow, look and feel. I believe that Becker makes some that have the features you want with a reasonably OE look.
I can help with
* Reading Codes / Coding your car
* R&R FCAs, Tie Rods, Sway links....
Need an RTAB tool? Or clutch fan and water pump tools? PM me.