I would say it depends on personal taste and PC power, really. Some folks like to toss in all the details they can, while others tend to be more economical with the details and rely more on mapping. Up close, the detailed model will look more realistic and work better as an image but it will require more time to create, prepare, and render. Yes, anytime you add extra geometry to your work, you will end up with more texture work. They go hand in hand. Certain types of details can make texturing a tedious task but I doubt, for a console, that it would be really more difficult. That's two bits from an organic modeler...may not be worth as much. You should check with your bank. :)