Do new integrated kitchen faucets come with threads for adapters?
The second Delta faucet that you linked is not going to be at all compatible with your fish tank cleaning system. The first VCCUCINE unit may be usable if the aerator on the non-spray spout is removable. It looks like from the view below that it may be removable as per the small flats on two sides:

 

...but it would not be fun to have to remove that part every time you wanted to use the fish tank cleaning adapter.

Also be aware that there a plethora of sizes of threads used for faucet aerators. Some are internal (F type) threads and others are external (M type) threads. Then throw in inch and metric sizes and realize that there will be a good chance that your existing faucet adapter may not work with a new faucet even if it does have a conveniently removable aerator.