Kayaks are much more versatile than SUPs, especially for fishing and any kind of wind or current. Smaller learning curve too.

I'd recommend looking for a boat about 12' long. Will still be small/light enough to car top or truck bed carry, but more stable and versatile than the really cheap 10' models, especially for a full grown American adult male.

Avoid the cheap inflatable kayaks. Unlike the SUPs, they are not good.

If storage or car space is a primary concern, go SUP, and go inflatable, but buy a pump that will run off your cars 12V or a battery. Hand pumps destroy any convenience factor lol.