been printing for several years now, lots of functional parts. esun has always been great but really anything off amazon.
Have found some of the cheaper spools tend to have more cross overs on the spool which snags the print but otherwise there not much difference.
Also some of the cheaper ones have had more issues with bed adhesion.
Go with PLA+ rather than PLA as its definitely stronger nearer to ABS. generally rigid and easy to print.
Used to use ABS quite a bit also but it can be a bugger to print without an enclosure due to bed adhesion and warping. It has more flex in it and layer bonding is a bit stronger but with PLA+ theres not much need for it now anyway for most indoor use case.
For outdoor stuff might want to look at PC (polycarbonate) as its more resistant to UV, but its a can be a bugger to print similar to ABS.
PETG: fairly easy to print, quite a bit of flex and very good layering bonding, so doesn't snap as easy as PLA. Not ideal if you want rigid parts though.
Nylon - probably dont bother

needs a dryer and enclosure before even considering. Lots of flex but super strong layer adhesion. Good for things like gears.
Carbon fibre infused: Mostly a buzz word and overly expensive waste of time. The fibres are to short to create the interlocking which gives proper carbon fiber its strength. The specialist printers that print continuous carbon fibre are needed to print parts worthwhile.
Have had a PrusaXL on pre order since it was announced but might cancel it and get a bamboo carbon instead.
Thingiverse is the only site ive found with much pinball related stuff on it.