It's more about picking a turbo that is right for the engine it will be installed on, and the intended use of that engine. There are many factors involved. The compressor map for the turbo can tell you a lot about how it will perform on your engine.
A big turbo will spool at a higher rpm, but have the potential to make more power. A small turbo will spool at lower rpm, but it will be limited on how much horsepower it can make on the top end. Putting a huge turbo on your engine does not mean you will instantly make huge horsepower, because there are so many other modifications and upgrades needed to make that happen. Also, running a lot of boost does not always translate into a lot of horsepower. Making horsepower is about flow.
You can look at the engine as a big air pump. You can run all the pressure you want on the intake, but if it can't flow through the engine because of cylinder head and exhaust restrictions, the power will be limited. If don't have a sufficient fuel system to match the increased pressure and air flow, you could run lean under boost, and that is a major cause of engine failures. Or, if you are running too much boost and not enough octane to resist detonation, major engine failures can result.
Another thing to consider when choosing a turbo, is that a huge turbo can translate into huge lag. If you are going to drive the car on the street for the most part, having a turbo that doesn't spool until 6k rpm is not going to be as much fun as it may seem when you look at that massive turbo in your engine bay. If you hit full boost at 5k and the rev limiter is at 6200, it's going to be fairly useless. Many a Supra owner has been embarrassed by another car making far less horsepower, but spooled faster and had a wider powerband.
I experienced this first hand when I was lined up with a friend a while back. He had a <300whp 1jz with stock twins, and I had a 400whp 7m with a (kinda) big Garrett turbo. We were going about 50mph, and we both hit the gas. By the time my turbo spooled, he had already pulled about 2 car lengths on me. I couldn't catch up until the top of 4th gear. He had a wider power band and faster spool.