Yes, the max on the 105mm is 1:1. You can go past 1:1 with the Raynox adapter added to the end of the lens but then the depth of field is extremely narrow and you have to be even closer to the subject. You lose a lot of light and then it becomes harder to handhold (above are handheld).
BTW, macro lenses aren't zoom lenses. They're fixed focal length lens so you have to move around to get the shots. What you're describing would require cropping or a very long macro lens to look further into the tank. I've shot pics from pretty good size tanks and the 105mm does well as long as you know how to use it.
As for macro shots that fills the image with just the tip, most of those are with macro lenses, but some of them not even at 1:1. All you have to do for that type of shot is shoot it at a specific angle.
Here's an example of that. RR Pink Floyd shot from the side to get the profile image.
Same coral and shot at the same f/stop, but from a different angle.
You can even get more blur by just opening the lens up even further or vary the angle to separate the focus point from the background.
You can also add something like the Raynox 250M to the end of the lens and go past 1:1. Here's the edge polyps of the pearlberry shot at f/45 at ISO 6400, also handheld.