The limits of performance in processor architecture are the predictability of instructions and data, with the usability relying on the design and tools available. There are open source and closed source options such as RISC-V, X86, and ARM, with each having their own benefits and drawbacks.