That's what you were thinking right. Not much to say from this bridge besides go at night of course when the bridge is lit up. I will burst your bubble by letting you know its not much like Mario Kart. The bridge does light up sometimes but not enough to really capture your imagination. I will also say it can depend on the day sometimes it looks good and sometimes it doesn't seem to be on but other than that it's on your way to Odaiba so just go and see the giant Gundam on your way, you'll see it at night anyway.
An amazing bridge. You can walk its length or enjoy stunning views from the train. It is fair to say that the bridge looks better at night time, illuminated by the colours of the rainbow.
Around December time, you can enjoy a special firework display held every weekend (best viewed from the Decks building), that captures the essence of Rainbow Bridge, Tokyo Tower illuminated behind it, and a stunning scene of fireworks in the foreground.