OK here's what I came up with. Suitable only for anoraks.
You need MS Excel. Not for most people's taste I suspect but it saves time for me and is more accurate than typing.
1. Put in the CD and let YADB fail so that Unknown Artist and Unknown Album are filled in.
2. Rip CD to filenames like "1 - Track 1.OGG" etc.
3. Rename the files from a DOS command window thus:
In MS Excel.
Column 1 contains the list of tracks from wherever you find them (no track numbers etc),
column 2 contains 01, 02, 03, ... etc.
column 3 contains Track 1, Track 2, Track 3, ... etc.
and column 4 contains this formula copied downwards
=CONCATENATE("ren """,B1," - ",C1,".OGG"" """,B1," - ",A1,".OGG""")
Copy the results and paste them into the command window.
4. From MC delete from library and re-import.
5. Fill in artist and album details in the Tag Info
6. From Library Tools, Fill Properties From Filename with Filename ONLY checked enters the songs names for you.
7. Optionally Library Tools - Clean File Properties
8. Library Tools - Rename Files From Properties puts everything in the right folder.
If you answer 'no' when it asks to delete subfolders your DOS command window can be used for the next cd.
Sad, huh?
[edit]
BTW, to work correctly this needs to rip filenames in the format [Track #] - [Name] and I'm using OGG