You could simply choose one from a variety of online vendors and get one delivered, too, BB isn't the only option. The RC-330 I'm pretty sure is from the time (2009-12, the manual dates this model at 2010) Onkyo had issues with network/hdmi boards (heat) and extended the warranty for a few years but that's over. Not even the same Onkyo owners now (Onkyo is now owned along with Pioneer by essentially Klipsch). I have a model from that range (RC-370) that did get the issue right towards the end of the extended warranty period and has worked like a champ ever since their fix.
Does the unit stay powered on long enough for you to run a reset? I'd try that first. Here's the manual
https://assets.onkyo-av.com/product-manuals/SN29400567_HT-RC330_En_web_2022-11-02-204354_djhv.pdf?v=1667421834 and the troubleshooting section has the reset instructions on page 43 (you might just go thru the troubleshooting section a bit, too).
The RC330 I believe was primarily sold with one of Onkyo's HTIB 5.1 speaker sets....is that the speaker set you have? Or what do you have?
Costco usually has a nice lower price point avr on sale, too. The Yamaha you linked would be similar to all the major manufacturers in this price point area. You can use this site to look at particular differences between units
https://www.zkelectronics.com/