Thanks guys, I was really interested to read that I hadn't missed something simple. I think
metelus and others have found the path to follow outside SONAR.
The issue is that some tape is 2 track, some 4 some mono, some stereo. Some is recorded at 15ips, some at 7, some 3.5 and - just possibly - half that. I don't have all the playback machines with all the speeds.
Also some of the tape is very old (1960s). Some of it is studio, some just mics left hanging out recording live at gigs, some it is demos. Often you only get one real shot at threading to find out what you have.
But I know that recording and playing back with a Roland RAP-10 card in the 90s worked just fine. That Roland card was bundled with ATW (Audio Tool Works): all you had to do was tell ATW to play at double the sample rate in an simple varispeed playback.
So I think that Audacity (which I've used) could work just the same. Great suggestion - I will report back shortly!