Well, kind of. Some apps get entitlements to prevent showing TCC popups; some don’t, like Weather. And if you look in Settings, you will find that Camera shows that it was using your location, just like other apps on your system. (FWIW: I believe that dialog is specifically for apps that use your location in the background, so Camera won’t trigger it anyhow.)