The only problem with the Surface Pro (mentioned by Nerian) is that it's probably going to fall more into the laptop category as far as price goes. (They haven't released the price on it yet, AFAIK.) Still, if you're looking for a tablet that does basically everything a laptop or desktop does, a Windows 8 tablet is the way to go. IMPORTANT NOTE: There's also something called "Windows 8 RT," and there are some pretty slick tablets available that use it. It will not run all of your old windows programs, though. (Its primary advantages over Windows 8 tablets are price and battery life, not power or flexibility.)
So if you're looking for something to take the place of a laptop, Windows 8 is a good bet--but check whether it's running Windows 8 RT or the full Windows 8.