I have hauled kayaks with a Toyota Corolla in the past.
Things to consider - how old/tall/strong/fit are you compared to the weight of a kayak. They are quite a bit heavier after a long day of fighting the wind. I’ve found I’m not quite as young as I was 20 years ago when I started kayaking. A neck surgery and a shoulder replacement makes me glad I have a pickup to haul my kayaks. They make little trailers that you could pull behind a kayak.
My favorite boat is one of those single person pontoon boats. Mine is like fishing from an Easy Boy recliner. I dumped the oars, and move about using scuba flippers. Boat control is much easier, and I can troll easier than with a no peddle drive Kayak.