No! Inflatables will not cut it.. you got that bit right.
Not getting personal but consider what you weight and your ability as two main critical factors before buying a Wave SUP.
If you are say ITRO 85-95k early intermediate then a 9’2 x 32” thruster will be good. Work downwards on weight and sub 9’x 29” is going to be flicky. Work upwards of weight and ability is on the larger scale and 9’8×33” or a 10’x32 long board would suit.
I suggest you pop down to Staunton one day and go ask similar weight riders and abilities what they are riding, they’re a friendly bunch so no problems..
Brands? Yeah, well I have my own thoughts on what you should buy.. but if you have the cash and want new then Redwoodpaddle (no, not Red Paddle) they do a great range in all sizes for €600- €700 and I can put you in touch with my mate whose the Brand Ambassador if you like.
Other than that S/H is a good place to be, accept a few dings and a few yrs old and all should be fine.
Alloy paddles are heavy and cheap and adjustable, £60-£70 ish, carbon fixed are about £250.
Enjoy, wave SUP is awesome.