I have had this one for years, and I’ve used it mostly at LJ Shores, Mission Bay, and Coronado. Never had an issue with it getting punctured. It fits in a large bag that’s included, fits in the hatchback of a Prius, and it’s about 50 lbs. so I can haul it in and out by myself.
Will you be driving to and from your kayaking locations? If so, an oru (starts around $800 for the inlet) might be a good fit. They are foldable kayaks. Didn't like my beach lt so I sold it, but a lot of people are fans.
Do you have storage space and don't mind lifting 50-80lbs the Walmart kayaks are on sale right now (in store prices are lower than the web prices as of this morning) for around $250 and are decent for casual river use and flatwater, protected bays etc.
Are you limited on space? Go for an inflatable kayak. Sea Eagle and Intex have some great models that can handle anything from flatwater to class III white water or just casual kayaking.
Planning on doing some hiking and want to combine back packing with kayaking? You may want to look into a pack raft. Kokopelli Packrafts or Alpacka Packrafts. Perfect for mountain lakes, rivers, protected bays even whitewater. And they only way 5-10lbs so you can literally take them anywhere including as carry on with a plane!
If you doing fishing, you want an angler kayak which is a wider and longer boat that is sit on top and heavy, stable for a solid fishing platform.
If you are doing ocean or sea kayaking you will want/need a sit inside kayak rated for the open water.
What I usually tell my friends is...
If you want something to use infrequently, and don't want to worry about it, maintain it, or spend alot of money and have an easy means of transporting it (pickup, live near water etc). Go for a lifetime or walmart style sit on top hard shell kayak.
If you live in a apartment, don't have a lot of storage and have a small vehicle, go for a mid range inflatable kayak. The difference in performance isn't going to affect you that much for what your probably going to do with it.
One season of either the cheaper hardshell or the inflatable kayak is going to tell you if you like it or not and will help you to decide if you want to spend $800-2000 on a higher end pack raft, inflatable or hard shell kayak.
Also, its never a waste, because as you upgrade, you then have extra boats for friends and family.