Pack rafts were designed originally for the Brooks Range in Alaska as a way to run remote creeks that were otherwise impractical or impossible to get boats to. They weren't originally designed for improved urban storage, but that is certainly a huge auxiliary benefit. Packrafts will have limitations relative to a hard boat, like a canoe/kayak, mainly in the performance and equipment storage departments. It is up to you how much those limitations matter. If you simply don't have the ability to store a canoe then you might just have to live with the limitations.
Performance wise a canoe will do a bit better for lake travel over long distances. It'll track better and have a higher average/top speed. My exposure to packrafting is for whitewater use cases so I can't speak too much about high winds/exposure on lakes/etc. But you can certainly take a higher end packraft down class IV whitewater if you have the skills. They are very capable crafts.
Storage wise you can always pay a bit more to get a Ti-Zip built into the packraft. This increases your storage space a lot, and helps keep your stuff nice and dry. If you pack light weight gear you can definitely pull of mulitdays in packrafts. People do the 200+ mile Grand Canyon section every year in packrafts.
If storage and transport are issues I think you'll have a great time with packrafts. It'll probably be more at home on the river trips than the lake trips you mention. You might just need to plan your trips accordingly by limiting long mileage days, checking weather carefully, picking "protected" water routes, and packing light.