The product I want to build next is a niche product for a very specific (but quite large in absolute) terms demographic, profit per user (after tax/VAT/Hosting minus staff) is approx $6 per month, at 500 users I'd be doubling my current income, at a 1000 I'd be able to work on it full time, at 2000 I'd be very comfortable, anymore than that would just be gravy.
It's not even a difficult build (I've built much more complex projects for clients) but the market doesn't exist at all (which means it's either a really good idea (unlikely) or a terrible idea (more likely)).
In either case I'm gonna give it a shot since it's a product I'd have bought if it existed immediately and happily.
The good bizarre ones could wipe out an existing industry. That's what makes them interesting.
Good ideas may look good, but good-looking ideas capable of creating huge companies (thus great) are almost certainly tested already, so you are either wrong or late to the game.
Of course, YMMV. Nobody ever agrees on what an idea looks like.