In the near term the biggest reason to do multiple launches in a day will be orbital refueling. This is required for sending much, much larger payloads to the Moon and Mars. It will require on the order of 10 launches to fuel up one moon lander in orbit, and obviously doing that as quickly as possible will be beneficial. NASA has already committed to this plan for Artemis.
Require, or just make comfortable? Saturn V had the lift capacity of "only" a couple of Falcon Heavies, but was enough to carry astronauts, a car, a lunar lander with enough fuel to take off, and a command module.
If you really got order-of-magnitude gains from an expendable upper stage, it wouldn't be that exciting to have reusable rockets (which are more complex and still only fly one order of magnitude more times) in the first place.
The HLS (Spaceship) will need many refuels at orbit in order to get to the Moon and back. That means at least a dozen of fully-loaded Heavy launches to LEO just so each one of them can load a bit of fuel into HLS. The fuel in orbit can't sit idle for too long, or it deteriorates; I haven't found a limit on days for that, but a week-long launch window is considered a dealbreaker, we're talking a dozen Heavy launches in a week.
It's either a short launch window, or at least 6 Starships built and launched twice in ~10 days. Don't count out on SpaceX building 12 Heavy Starships just for that Artemis mission.
200 years ago, there was no need to use electricity. 100 years ago, there was no need to use a programming language. 30 years ago, there was no need for gigabit wireless Internet.
Counterexample: space stations. We've had small manned space stations for decades now, but no real application for them. They're national prestige items only.
https://www.nasa.gov/missions/station/five-space-station-res...
We have the means to build pyramids or moa statues (Easter Island-style) much more quickly and efficiently that the ancients did, but we don't feel the need anymore.
Other use cases include launching and maintaining satellite constellations (Starling / Starshield), and launching singular large payloads like space telescopes.
Even for smaller payloads, having both the first and second stages be reusable will reduce launch costs.
We are insatiably curious explorers. The cosmos calls to us. Many are willing to do anything they can to answer that call.
It takes a heavy launch rocket to launch heavier things into space or missions, refueling, and to goto other planets.
Besides, Elon is the first to go after supervillain territory.