The DEC Alpha actually did provide very good performance, and you could even run Windows NT on it. As far as I can tell, the biggest problem was just that Alpha systems were very expensive, and so they had a limited customer base. There were some quirks, but the main thing was just that you'd be paying $2000 for a PC and $10,000 for an Alpha based system, and most people didn't need the performance that badly.