has anyone ever seen cascading candle holders or some kind of holders to put candles cascading down on a three tier cake?

Yep!!
I think I still have some but I am thousands of miles from where they are.
Wilton featured them back in the '50s & '60s