You can get really close to the big swimmers under water at the Florida Aquarium in Tampa. Turtles, sharks and sting rays swim right up to the glass. The sting rays look like they have happy faces when they swim up.
You can swim in the exhibit with the sharks. Not sure if that pole he’s holding would calm my fears. I’m sure they keep them well fed though.