I bought a single seater one for about £200 about 10 years ago. I fancied giving it a go and a mate was going to get one as well. I had a Honda S2000 at the time so inflatable was the only option as it fit in the boot. Used it 3 times or so as my mate bottled out of buying one after I bought mine (annoyingly).
Seemed pretty good and inflated / deflated well – handled ok on the river I used it on. I’m not a skilled ‘kayak-ist’ by any stretch of the imagination though.
I guess a rigid one would be better if you can transport it / store it though. The sea kayaks look more stable from what I’ve seen.