My understanding is that the (expired) designation basically goes like this.
Tier 3 - regular infantry and regular soldiers
Tier 2 - special operations soldiers. Picked from the best tier 3 soldiers. In the US this would be green berets, 75th rangers, navy SEALs, marine recon
Tier 1 - the elite special operations soldiers. Perform counterterrorism, hostage rescue, targeted assassinations, etc. They are pulled from the ranks of the best tier 2 soldiers. DEVGRU pulls from the other navy SEAL teams. Delta force pulls from the 75th rangers and the green berets.
Are there any units above tier 1?
My impression is that by the time you are an expert in a tier 1 unit, you are about 40 years old. You need the health of a professional athlete to function as a tier 1 specialist. You may join the military at 20, spend a few years in regular infantry, then join a tier 2 unit and spend several years training and performing operations. By the time you join a tier 1 unit and complete the 1-2 years of training you are close to 30.
There are very few professional athletes who are 40 years old for a reason.
Having said that, I get the impression there is something akin to a level above tier 1.
CIA SAD/SAC and the intelligence Intelligence support activity (ISA). These groups perform very dangerous paramilitary missions and intelligence gathering operations. They may not have units on a higher tier than delta force or DEVGRU, but they like hand pick the very best operators across various classes of tier 1 units to perform missions.
The mission to kill Bin Laden. It is my understanding that there are roughly 200 members of DEVGRU, but when the assassination of Bin Laden was organized, they hand picked the best operators from all the different squadrons of DEVGRU. They didn't just send red squadron or gold squadron to perform the mission. They hand selected the most experienced and most talented members from across all the squadrons and formed them into a team of ~20. This would be another example of a unit above tier 1.
Another example would be intelligence gathering squadrons within tier one units.
Of the squadrons of DEVGRU, black squadron is the intelligence gathering squadron. In Delta force, it is G squadron. Supposedly these are the most elite members of DEVGRU and Delta force, and supposedly these are the ones who get pulled to work with the ISA. These are the ones that go undercover into very dangerous areas and perform intelligence gathering. I would not be surprised if DEVGRUs black squadron, Delta forces G squadron and the ISA are all inside the Gaza strip right now gathering intelligence to give to Israel's military and units like sayeret matkal so they can perform raids to kill Hamas militant and rescue hostages.
But as far as groups like the CIA SAD/SAC, do they hand pick the best members of assault squadrons of Delta and DEVGRU and organize them into teams to perform paramilitary missions?
My impression is that its not possible to have units above tier 1 because by the time you finish your career in tier 1 your body is broken down due to 20 years of military service and being middle aged at that point.
But the examples I listed above seem to provide situations where the best members of tier 1 units are hand selected to perform special missions, making them arguably groups who are more elite than tier 1.