Hi Ivan,
In general, for indoor mapping, we recommend cameras with a wide field of view (fisheye cameras). Here you can see 2 related Community posts, where other users share their opinion and knowledge:
Wanting to purchase an indoor photogrammetric camera and software solution
interior image acquisition tips?
For outdoor terrestrial mapping, any good commercial camera with > 12 MP should give you good results. See some recommendations here: Configuring the Camera Settings
2 examples of underwater projects from our blog:
Diving into Underwater Photogrammetry
Underwater Mapping for Coral Reef Surveys
I hope it helps 
Let´s see what other users have to say…