My personal favourite for indoor use on Sport Court was the Verbero Aero puck. http://www.hockeyworldblog.com/2011/07/06/verbero-sports-aero-puck-review/
The Aero puck slid better than the rocket, bauer and IDS. It also stayed flat better than the Rocket and IDS. The Bauer stays pretty flat and has more weight like an ice puck, but doesn't move as well as the Aero.
The Rocket puck is the default puck for most of the leagues with tournament players simply because it's used for tournaments like NARCh. The Rocket puck was founded in 1999 by Daryn Goodwin who also owns and runs the NARCh Tournaments. So even though pucks like the Aero came out that were better, league owners continue to use the rocket puck because they know that's the only puck that will ever be used at NARCh due to Mr. Goodwin's financial interest in both companies. The IDS puck is the official puck of AAU USA & USA Roller Sports.
Since the Aero puck wasn't the official puck of any major tournaments or leagues, it died out even though it was a good product. The Bauer puck has better distribution in my area than the other pucks around here since you can actually buy it in store instead of online only, but since it's not used in any of the leagues, I don't know how long it will be around.
Another puck that's interesting is the new Hoplite puck. It uses an internal gyroscope distributes momentum to keep the puck flat. I haven't used one yet, but it sounds good in theory: https://www.hoplitepuck.com/
It'd be cool to have an updated comparison that includes the Aero puck and Hoplite, but I know the Aero is in short supply now.
Coast to Coast does seem to have some Aero pucks in stock: https://coasthockeyshop.com/collections/inline-roller-indoor-oudoor-hockey-pucks-balls-biscuits/products/verbero-aero-puck?variant=12452384644