Yes supercomputer still exist, and yes they still wipe the floor with anything you could get for home.
However they are no longer top secret hardware, with superchips that cost millions of dollars. Now, they are mostly made of clusters of market level hardware.
As of June 2010, here are the top 5 Supercomputers in the world:
1. Oak Ridge National Laboratory's Cray XT5 "Jaguar" - USA
The XT5 partition contains 18,688 compute nodes in addition to dedicated login/service nodes. Each compute node contains dual hex-core AMD Opteron 2435 (Istanbul) processors running at 2.6GHz, 16GB of DDR2-800 memory, and a SeaStar 2+ router. The resulting partition contains 224,256 processing cores, 300TB of memory, and a peak performance of 2.3 petaflop/s (2.3 quadrillion floating point operations per second).
2. National Supercomputing Centre in Shenzhen's "Nebulae" - China
System Family - Dawning Cluster
System Model - Dawning TC3600 Blade System
Computer - Dawning TC3600 Blade, Intel X5650, NVidia Tesla C2050 GPU
Vendor - Dawning
Application area - Research
Installation Year - 2010
Operating System - Linux
Interconnect - Infiniband QDR
Processors - Intel EM64T Xeon X56xx (Westmere-EP) 2660 MHz (10.64 GFlops)
3. DOE/NNSA/LANL's "Roadrunner" - USA
System Name - Roadrunner
Site - DOE/NNSA/LANL
System Family - IBM Cluster
System Model - BladeCenter QS22 Cluster
Computer - BladeCenter QS22/LS21 Cluster, PowerXCell 8i 3.2 Ghz / Opteron DC 1.8 GHz, Voltaire Infiniband
Vendor - IBM
Application area - Not Specified
Installation Year - 2009
Operating System - Linux
Interconnect - Infiniband
Processors - PowerXCell 8i 3200 MHz (12.8 GFlops)
4. National Institute for Computational Sciences/University of Tennessee's "Kraken" - USA
Kraken Cray XT5 system specifications:
Cray Linux Environment (CLE) 2.2
A peak performance of 1.03 PetaFLOP
99,072 compute cores
129 TB of compute memory
A 3.3 PB raw parallel file system of disk storage for scratch space (2.4 PB available)
8,256 compute nodes
Each node has:
Two 2.6 GHz six-core AMD Opteron processors (Istanbul)
12 cores
16 GB of memory
Connection via Cray SeaStar2+ router
5. Forschungszentrum Juelich's "JUGENE" - Germany
Site Forschungszentrum Juelich (FZJ)
System Family -IBM BlueGene
System Model - BlueGene/P
Computer - Blue Gene/P Solution
Vendor - IBM
Application area -Research
Installation Year - 2009
Operating System - CNK/SLES 9
Interconnect - Proprietary
Processors - PowerPC 450 850 MHz (3.4 GFlops)
******
My personal top 5 list of Supercomputers:
1. SkyNet - Terminator Series
2. WOPR - Wargames
3. Colossus & Guardian - Colossus: The Forbin Project
4. Deep Thought - Hitchhiker's Guide To The Galaxy
5. I.N.T.E.L.L.I.G.E.N.C.E. - Team America: World Police