Performance wise, there is no contest. The 060 is significantly faster per MHz and the slowest one available already starts at 20% higher clockspeed than the fastest non-overlooked 040.
That said, I find my humble 25MHz 040 adequately fast for my 68K needs. It's a lot faster than the stock 020 my machine shipped with.