I want to know the appropriate idiom to use when describing something or a situation which has a high name or a good reputation but in reality it is a disappointment.
You can say simply that it didn't live up to its reputation.
If you want something a big more fun, you can say it was all sizzle, but no steak.