This is what I could gather from answers on Stack Overflow. I have no development background, so corrections are welcome.
Camera could have only have one object as mentioned here. But this was depreciated from Android 5.0. So, devices running KitKat and below, cannot have this feature.
It seemed to be possible on some devices to open both front and rear camera as mentioned here. However, it is not possible on all devices due to hardware & Software restrictions (see comments)
The Android camera APIs generally allow multiple cameras to be used at the same time, but most devices do not have enough hardware resources to support that in practice - for example, there's often only one camera image processor shared by both cameras.
- The link in your question is the best I could find for a clear explanation.Nokia, Samsung, LG seem to have started this trend on some of their devices. Such devices either need Dual Camera Mode or Dual Sight Mode. There wasn't much I could find about these OEM specific technologies. The Frontback Camera app mentioned in the link, works on Pixel 4a Android 11. Note that the pictures were very grainy and not worth the result IMO.
OP tried apps mentioned here and they didn't work.
This leads me to conclude that it is both a hardware & Software feature and apps can be poor substitute. I doubt if trying on other devices would show better results. Neither have I come across any rooted or Xposed modules that can do this, so it is best to buy the devices that support this natively, if you want this feature badly.
2024-07 Addendum
- As of 2024-07 end-users don't have a way of predetermining through the Google Play Store which devices support an active dual camera/Bothie mode before purchase as the Google Play Store doesn't have an appropriate filter that app developers can mark.
- Developers of apps for devices pre-installed with Google Play Services can check the Performance class at runtime to see if concurrent dual camera operation is possible.
Android App developer notes:
Relevant Android Developer documentation: https://developer.android.com/media/camera/camera2/multiple-camera-streams-simultaneously
Proof-of-concept: https://github.com/ananthrajsingh/front-rear-simultaneous-camera
From: https://developer.android.com/topic/performance/performance-class
To find a device's performance class level, use the Jetpack Core Performance library. This library reports the device's media performance class as declared in the build version information or based on data from Google Play services.
Devices released with Google Play Services should follow the Android Compatibility Definition Document (CDD) for their initial release OS version
So Performance Class 13 should support dual active camera function.
Android CDD for Android 13 Section 2.2.7.2 Camera
[7.5/H-1-11] MUST implement concurrent front-back streaming on primary cameras.
Just be aware that the performance class info can be spoofed in a custom ROM but that still means hardware limitations apply.