Addicted to buoyancy

Hello all, this is my first post on Surfing Waves and I am seeking surfboard advice.
Some background:
I am not a beginner. I don't know what to call myself. I've been surfing for 23-ish years but I have never progressed past a certain point. I grew up in Hawaii but I don't shred. I know my way around a wave but I'll always be part kook. I learned on a crusty old '70s 7'6" pintail semi-gun. I surfed shore breaks, town and country on that thing. It was very fast but very thick and floaty as was the style for those boards. In the early 90's, I eventually upgraded to a used fat man's thruster. As a lightweight young adult it floated me like a longboard. I surfed some terrifying waves on that thing and pretty much scared myself out of the water for a while after an unwise session and a long time under water. Eventually I transferred to a university in a landlocked state and was only home in the Islands for holidays. On those trips home I borrowed or rented longboards and fell in love with the glide and the easy paddling. After graduating and moving to New York City, then various Long Island towns I stayed with long boards. Now in Torrance, California I'm still riding the last board I bought in New York 12 years ago. It was a barely used 9'6" x 23" x 3.25" single with a forgiving rocker. Lots of float on that boat. Now, 12 years later it's still my main ride from ankle-biters to head high.
The present:
My surfing frequency has always had ebbs and flows -- sometimes due to chronic/recurring injuries and sometimes due to apathy. Right now I'm in a flow phase and I'm reinvigorating my love for surfing. When I surf a lot, I feel better about everything. The problem that I'm having lately is that I'm starting to feel limited by my old log. It's fine for a lot of breaks and conditions, but for juicier waves it's too damned slow. On many steeper waves, if I can't get up early, top turn and speed through the initial section on the nose, then I'm screwed. When I drop in more vertically and bottom turn I often can't catch up with the shoulder. No matter how hard I pump I keep getting stuck just behind. My theory is that my banana rocker'd board just bogs down on the flats plus it has no drive. I feel like I need a flatter board for more speed. I also feel like I'd enjoy a looser, livelier, drivier board. And, I'd also like a board that fits nicely inside my hatchback. 8'6" or shorter works for that desirement.
Sooooooo.....
Here's the thing. I've gotten used to floating and paddling pretty high on the water. I weigh 200 lb (91 kg or 14ish stone). Not super big, I know, but big enough to sink most shortboards. I've borrowed and tried some smaller boards (fun shapes and mini-mals) and hate the feeling of being so low in the water. It probably didn't help that these were banana rocker'd beginner boards as well.
Any advice on dimensions or shapes for a transitional board that might click for a 40 year old 200-lb buoyancy addict trying to get off the foam? I understand that I'll need to get my paddling muscles into a different kind of condition to effectively use a less floaty board, but if the ride is worth it, I'm willing to put in some work.
Thanks.
Some background:
I am not a beginner. I don't know what to call myself. I've been surfing for 23-ish years but I have never progressed past a certain point. I grew up in Hawaii but I don't shred. I know my way around a wave but I'll always be part kook. I learned on a crusty old '70s 7'6" pintail semi-gun. I surfed shore breaks, town and country on that thing. It was very fast but very thick and floaty as was the style for those boards. In the early 90's, I eventually upgraded to a used fat man's thruster. As a lightweight young adult it floated me like a longboard. I surfed some terrifying waves on that thing and pretty much scared myself out of the water for a while after an unwise session and a long time under water. Eventually I transferred to a university in a landlocked state and was only home in the Islands for holidays. On those trips home I borrowed or rented longboards and fell in love with the glide and the easy paddling. After graduating and moving to New York City, then various Long Island towns I stayed with long boards. Now in Torrance, California I'm still riding the last board I bought in New York 12 years ago. It was a barely used 9'6" x 23" x 3.25" single with a forgiving rocker. Lots of float on that boat. Now, 12 years later it's still my main ride from ankle-biters to head high.
The present:
My surfing frequency has always had ebbs and flows -- sometimes due to chronic/recurring injuries and sometimes due to apathy. Right now I'm in a flow phase and I'm reinvigorating my love for surfing. When I surf a lot, I feel better about everything. The problem that I'm having lately is that I'm starting to feel limited by my old log. It's fine for a lot of breaks and conditions, but for juicier waves it's too damned slow. On many steeper waves, if I can't get up early, top turn and speed through the initial section on the nose, then I'm screwed. When I drop in more vertically and bottom turn I often can't catch up with the shoulder. No matter how hard I pump I keep getting stuck just behind. My theory is that my banana rocker'd board just bogs down on the flats plus it has no drive. I feel like I need a flatter board for more speed. I also feel like I'd enjoy a looser, livelier, drivier board. And, I'd also like a board that fits nicely inside my hatchback. 8'6" or shorter works for that desirement.
Sooooooo.....
Here's the thing. I've gotten used to floating and paddling pretty high on the water. I weigh 200 lb (91 kg or 14ish stone). Not super big, I know, but big enough to sink most shortboards. I've borrowed and tried some smaller boards (fun shapes and mini-mals) and hate the feeling of being so low in the water. It probably didn't help that these were banana rocker'd beginner boards as well.
Any advice on dimensions or shapes for a transitional board that might click for a 40 year old 200-lb buoyancy addict trying to get off the foam? I understand that I'll need to get my paddling muscles into a different kind of condition to effectively use a less floaty board, but if the ride is worth it, I'm willing to put in some work.
Thanks.