I compared 7 different types of shells in this video.

I shot them from ~100 - 150 feet, using a few ranging shells so I'd be pointing to the right part of the sky.
They were shot in this order.

Shotgun Shells (Pyro King) 43.5 grams average
Blue(too dark a blue to see numbers)
Red (A23/7)
Maximum Exposure, 45.5 grams average
Green Peony
Red Peony w Blue Stars
Rambo Kids, 69.5 grams average
Golden and Green Peony
Silver Palm Tree
Excaliber, 140.5 grams average
Golden Crysanthemum
Crackles
Golden One (Kylin King), 63 Grams average (Donated by a friend)
White and Red Glitter with Red Bouquet
Green to Purple w Green Bouquet (Exploded in tube)
Super Magnum (Kylin King), 87 grams average (Donated by a friend)
Green Peony with Crackling
Sea Green and Purple Peony
Double Lightning
Double Red Tail to Blue star and Silver and Blue Star
Double Silver Tail to Crackling, and Crackling.

All except 2 tubes were 12" pyrogear tubes. I tested the second Excaliber, and the second Double Lightning with 15" Pyrogear tubes.
The first Excal had stars that almost touched down, but the second one did get a higher lift.
The Kylin Kings were nice, but they might have been better in a taller tube also since they seemed low, and stars almost touched down with the second one of those.
With Double Lightning I think the higher tube helped with directionality, but not sure it helped much with height, the shell going off going up might have been a fluke.

Before the test, the weight difference alone had me thinking the excals would really impress me the most, and although they did have the best bang, the extreme asymetry of the Crysanthemum had me less impressed.
Almost all the shells had something going for them.
The premature burst in the tube has me less impressed with the Golden One, but I admit 2 shells is a small sample.