I've tried it and depending on the router, it creates chaos. You don't have fine-grained control over what frequency your device(s) will connect to, sometimes devices roam frequently, and there is latency involved in switching SSIDs so if you're on a call and your device roams, your audio will stutter. And also what tends to happen is most devices hang on to the 2.4 GHz band... since 2.4 Ghz tends to have the strongest RSSI, but also the slowest speeds and most interfence with neighbors given the limited number of channels.
So if your device is connected to the 2.4 GHz SSID, when you go to watch video in 4K on youtube or other services, the video buffers or renders in much lower quality than it otherwise should. And when the SSIDs for each band are the same, you don't know if the device is on the 2.4 GHz band, 5 Ghz band, and now, 6 Ghz band. So you may think there's a problem with your network provider, when the issue is your device is on the 2.4 Ghz band that is suffering from interference.
Having a separate SSID for each frequency allows you to avoid this mess altogether.