Most HDD camcorders dont have composite AV-in, let alone S-video. Even tape models with S-video in are very thin on the ground in the Consumer range these days. Some semi pro tape models stil have them
Some of the Semi pro Pro models also have Solid state HDD type Add ons to replace tape
Firestore is one of such tapeless solutions
10hr batteries probably exist but most can do 10 hrs as long life with continuous use without LCD use. With Start Stop , I doubt if any will
As for connecting a pin hole sized external lens , I don't know of any such camcorder.
I imagine there may be some specialist camcorders for sporting , dog racing ect as well as security which are well outside the realms of the mainstream
Good luck in your search