He would benefit from being a book-collector, I think. Books can be quite expensive as well, depending on what you want and where you look. But at least those offer content you can read, as well as information that's worth preserving for posterity's sake. Hell, you could even get into book restoration, though such is likely far more costly and labor-intensive. But at least it would be something to do, in your free time. Which Kevin has an excessive amount of.
Even with transformers collecting...
Kevin could get into painting or repainting models. He could do customs or just help touch up old models with bits of new paint. He could even do commissions to paint a wonky trans flag on your transformers for 15$, more tranch and transformers money.
Kevin could get into 3d printed customs with Bonnie's printer or custom clay or silicone parts. He could replace parts, build customs, and add new pieces to models who need extra. This too can roll into commissions and therefore tranch dollars.
Kevin could be playing the transformers stock market. This would require him waiting and not opening a toy, as well as make him have to buy less to have space for all those plastic boxes, but it would be an investment in the future and encourage him to only keep his favorites.
Kevin could start a review blog for transformers toys. Since he takes them out of the package, he could give long detailed reviews on quality if he learned what to look for and get donations for his advice.
Kevin could start assessing toys based on condition and learning how much they sell, becoming an unofficial appraiser.
Kevin could organize a transformers meet up. They could trade and buy models from each other. I don't suggest this since apparently he isn't a good janny or good socially, but it is something to think about.
Kevin could take photographs of his transformers toys doing different things in different dioramas and poses. It probably wouldn't bring in money but it would strengthen art muscles and bring him closer to the community.
Kevin could make some goofy ass transformers stop motion. Again, not much money but fun and fulfilling to share with your set of autists.
Kevin could be fucking taking photos of them then tracing over them for art commissions. Half the effort with double the tism.
Basically, Kevin could be doing a lot of things but he isn't and that's why even for a toy collector he's at the bottom rung of the barrel. The only thing that doesn't require effort or learning on his part is to stop buying so many toys, but he can't even do that.
Edit: no, none of this shit would stop him from being a cow with terrible spending (make him more interesting though), nor would he ever do them nor do them well since he's a trancher and they live a life of failure. It's more of a "he could be more interesting/still useless but hobby productive" this way. Even if Kevin got a job that wasn't tranch coordinator (lol), he'd still be mostly useless and a cow because all that cash would go to dumb shit and his attitude still wouldn't change.