about his PC, harkening back to what happened to him the day of his parent's funeral, the destruction of his statue of Roxy had the same equate to him as the only item he considered valuable
I suspect Rudy has CPTSD (post-traumatic syndrome from a series of events) and that this episode was an example of being triggered. People can get triggered when something in the present reminds them of a past trauma, and in these cases the response to the events in the present can go beyond what is appropriate for what is actually happening because their body is treating it as an emergency of the same caliber as the traumatic event from the past. It's like their body is saying, "last time we saw a situation like this, it did incredible, long lasting damage, so we've gotta treat this like a full-on emergency so the same thing doesn't happen again".
In this case, as you said, I think he connected the Roxy figurine with his PC on the day of the funeral and became dysregulated. When this happens to someone, their body goes into a sort of survival mode and the parts of the brain responsible for logical thought and memory go into a low-power mode or turn off entirely. I think that explains his crazy behaviour, not thinking through that the captive girls would need food/water, etc. The part where Rudy realised "oh, this would be easy to fix. I can just make another, better Roxy figurine, without much trouble" was when he started to become more regulated and the rational parts of his brain came back on line. The much more appropriate response became apparent to him.
Other examples of CPTSD / PTS in anime are Kiritsugu from Fate/Zero, Shirou from Fate/Stay Night, Koyomi Araragi from the Monogatari Series, all of the Hashiras from Demon Slayer, and Shinji Ikari from Neon Genesis Evangelion. All of these guys get triggered in their shows and display extreme behaviours. When it happens, some feel the urge to sacrifice themselves to save others (Shirou, Koyomi, and to some extent Kiritsugu), while others completely shut down (Shinji, who is a good example of hyper/hypo-arousal states).
The depictions in those shows are typically in the context of actually dangerous situations where that kind of triggered heroism/shutdown feeds the drama and is understandable even without the lens of mental illness. I think having Rudeus get triggered in a more mundane situation (figurine broken) is important in contrast to the other shows because although those more dramatic fight/freeze reactions and impulses to rescue/self-sacrifice are quite common, it is probably even more common in practice that people with cptsd / pts get triggered over something simple, overreact, and make poor decisions that will hurt them later. This is a very important aspect of these illnesses to portray because it makes it clear to the audience that there are substantial challenges faced by the people suffering from them. It also helps explain why people who should have intimate knowledge of trauma and every reason to keep others from suffering the same fate very often can become abusers themselves.