Any plants with deep roots will always require soil. These include deep-rooted vegetables such as potatoes, sweet potato, carrots, onion, and turnip.
The size of spread and growth will also be a factor for indoor gardening.
Naturally, space limitations will prevent larger plants from being grown in anything other than soil.