My 68040 Amiga is generally "fast enough" for most of my needs, including using effects in ImageFX (so I have to wait 30 seconds for an effect to render, no big deal). It's also fine for desktop publishing using Pagestream, CD-burning and 99% of the games out there (I don't do much gaming though).
However...."how fast is fast enough"? Well, I do a lot of music on my Amiga (MIDI stuff and 2-track stereo editing). The one thing I would like to be able to do is run a full multi-track suite (like HD-REC or Audio Evolution) on my Amiga (8-tracks minimum, but preferrably 16-tracks). If my Amiga could handle this, I wouldn't have to rely on a PC for this sort of stuff. I think at minimum an 060 is required to run any of the current Amiga multitrack software.
So an 060 would probably be enough for me (I'm hoping Natami actually is produced for this reason). An 060 Amiga would probably make me happy for a LOOOONG time.
However, talking entirely no-limits. The any Amiga that could handle doing multitrack audio, plus non-linear digital video editing would be the ultimate computer for me (probably not even the top of the line PPC would fulfill my needs). Even an older PC can handle this nowadays, so I do not require cutting edge technology, just something that can get the job done.