Honestly, I didn't even really notice this so-called "Extreme Close-Up".
I definitely think those other two camera angles should BOTH be used. Just in different situations. And I think I know how.
The dead-on fixed camera angle would be appropriate for oppressive (spooky, prison, industrial, etc.) environments, as well as archaic/retro environments (like if Yooka & Laylee were to walk inside an 8-bit arcade machine or something like that).
The moving isometric camera should probably be used more generally, in any areas with grass, sand, snow, etc. It feels more dynamic, flowing, and free.
These two camera angles evoke different moods, and I really think they ought to be used as such.