so long as you patch th xbes pretty much all emus will take advantage of the extra power though how there programmed effects how thatll happen eg pcsxbox prtty much gets no benefits from the xtra ram unless you want to use filters without a performance drop as its mostly cpu dependant mame based will take advantage of both cpu and ram th ram mostly for rom loading allowing faster load times/less lag in certan games due to having most the game in memory instead of using virtual memory like on a stock
it depends what your after really but hers a basic run down for individual things
CPU = more processing power which basicly boosts th performance in emulators like pcsxbox gaining better fps eg the latest test build tomb raider II'i think' runs a bit choppy on stock but a 1ghz is far better and a 1.4 is pretty close to perfect same with the syphon filter series stock runs crap but biggr processor renders it more or less playable from the test results i saw
xbmc obviusly also makes use of this extra power and puts it to use on playing video files etc you find it runs much smoother than it did before if your using a power hungry skin on it aswell
RAM = boosts mames performance quite a bit due to more memory for rom loading sicne it basicly takes out the need for virtual memory games as a result load and perform much quicker than before this might also apply to the final burn series of emulators aswell but im not entirly sure would have to check
xbmc will be less likely to lock up when using skins and running higher detail video files as its much less likly to frag with an out of memory crash
surreal gains a good benefit from the ram aswell as you can allocate more memory to rom paging and the dynamic recompiler than on a stock xbox the anti alias settings are dependant on the ram aswell so you can enable that aswell if you wish without worrying about a performance dip this emulator in paticurler benefits from botht h cpu and the ram boost whn it coms to high demanding games like goldeneye
pretty much every other emulator like pcsxbox neogenesis etc etc will make use of the ram and cpu but th ram will pretty much just apply to enabling filters without losing performance 'so if you want to run wipeout 2097 with HQ4X enabled the ram is for you

' generally thee emulators make better use of the cpus than the ram
cant comment on coinops as i dont use it so somon els would have to answer that in regards to being used on an ugraded box