What I DON’T recommend:

I bought one of the cheaper and smaller inflatable SUPs. It becomes rigid enough, but it is not stable enough even in very calm water—forget light waves like at the beach.

Make sure you get something that matches your experience level and the location you will use it.