Better is the sigma adapter...don't hesitate 

No, the maximum compatible filter size is 82mm 

it could work with a nikon f-mount (d3300) to sony e-mount( a7iii). 

The adapter is designed for Nikon lenses, including D mount. If the Tamron fits the Nikon D80 it should work. As for the lack of aperture ring on the Tamron ... not sure about that. Perhaps the Nikon D80 has an in camera aperture selection. 

The adapter will mount the lens and you will be able to use it manually. However, my copy of the adapter does not allow the lens to be fully mounted all the way until it clicks into place. It doesn't quite make it, but it's still very solidly mounted. Also, the manual aperture linkage doesn't work properly (on my copy, at least) so exposure is controlled only by shutter speed and/or ISO. You will be able to manually focus and zoom the lens but no VR, of course. It will be a frustrating experience. Instead, get a 14-140 Panasonic zoom if you can afford it!