Hi,
Nope. Its more complicated than that.
The CPU has cache memory and that's where the majority of its instructions and data come from.
Of course if the bit of data or next instruction isn't in cache, then it needs to be retrieved from main memory but a modern CPU predicts this and prefetches and predicts...
Also modern compilers produce code that is reordered for more efficient execution with caches in mind.
You may have heard of the Intel Xeon CPU? Well its a normal CPU exceptit has much more cache memory and so will run much faster. A relatively "slow" Xeon (say 500Mhz) can still outperform a P4 2Ghz under the right conditions.
Of course a really badly written application will run just as slowly as a mega-expensive Xeon as it will on a $100 celeron of the same speed...
But, in general, yes the bus speed does effect the overall speed of the machine greatly. A faster bus speed usually means potential for a faster system.
But there's no point in having a bus speed many many times faster than the speed of the fastest component on the bus...
Hope this helps,
Cheers,
Tim.