There's no end to the rods out there that would meet your needs. But offering rod recommendations on-line is a difficult matter because everyone's idea of the "Perfect" rod is about 80% subjective vs 20% objective. First, if you are concerned about casting leadheads out from a drifting boat, then stick with the spinner. This is not the strong suit of any baitcasting setup. It can be done, but an underhanded flip is about all you can expect to accomplish on a headboat, no "wind up and let it fly" type casting is allowed or even safe.
There's no end to what's available in the lighter rod world, and so Snapprhead's suggestion above is as good a place to start your investigation as any. Me, myself? I'm partial to Palmarius's rods and to Shimano's Grappler line as well.
If you can hold off 'til next Spring Dan from Palmarius is normally at both the Ward Melville High School show and the NJ SW Fishing Expo in Edison, NJ - which I never miss. He usually has his rods on sale at the shows with a steep discount and so that's where/when I buy mine. That's what I would recommend doing.
If you want to see some of Dan's rods in action - try Raf Sowi's YT channel
Raf Sowi Outdoors for a good idea of Dan's stuff being put to work. I've met Raf, who happened to also stop by Dan's booth at the NJ Show same time as I was there with my buddies, and had a fascinating back and forth discussion on rod design with him that took a good half hour. Smart guy.
As far as the new 2025 Revo beast 200, yeah, nah. Not with the 7.3:1 gear ratio. if I were going there, I'd look into putting the slower Winch gears into it - but then that kind of thing is what I enjoy doing. I know, I'm not normal, but it is what it is - I like my gear to be perfectly tuned to my preferences, so there's that. What with the cost of that new Beast plus the cost of a set of 5.4:1 gears, you could probably buy TWO Tatula 150P's for that kind of money - if you know how to shop reel prices. Hint: the place to look hard rhymes with "Eee-Pray."
I would STILL recommend the Tatula 150P over that Beast 200 (without the afore-mentioned gear change) - newest reel version or not.