You could easily spend a week in Osaka without feeling bored. But, for most people with limited time, a few days in Osaka would be good. For example, if you're coming to Japan for 10 days, it would make sense to spend a night and parts of two days in Osaka (and spend the rest of the time in Kyoto and Tokyo).