My wife and I recently had a very similar dilemma.
We love R2ing. But we also wanted to be able to do relatively comfortable overnight trips. We also wanted a boat that we could occasionally use to comfortably take friends on overnight trips.
9 times out of 10, we rented a Super Puma for paddling and loved it. When it was just the 2 of us and we wanted a more exciting ride, we would rent a Puma. However, both of those boats are too small, IMO, for hauling gear, unless you're comfortable being closer to the backpacking end of the camping spectrum.
We eventually settled on a 13'6" SOTAR SL (SOTAR can easily add 6" to the straight section of tubes). Overall, the boat is 6" shorter and 7" wider than a Super Duper Puma. I think the extra width is more beneficial for hauling gear, comfortably seating more passengers (when set up for rowing) and fitting a bigger dry box.
We feel like the 13'6" SL strikes the best balance between being an exciting paddle boat that we can R2 (or up to R7) and have the ability to haul enough gear for comfortable multi-day trips.
We were able to easily fit an 82" 4-bay NRS frame on the boat.
If you plan on doing a lot of camping (more comfort, less backpacking style), eventually you'll probably want to add a frame. You can still R2 with a frame, you just have to sit in diagonal corners. The frame makes hauling gear much, much easier. We've done paddle trips on smaller boats with this setup.
We have yet to take the SL on its maiden voyage, so I can't give you any feedback on its performance. I can tell you, however, that we love the design of the boat. I can also tell you that, in agonizing over our which boat to buy, every outfitter/guide and private boater that we talked to, who has paddled or rowed this boat, absolutely loves it.
P.S. Before you decide SOTAR is out of your price range, check their sales hot sheet.