More the merrier, if V8 is an option then I need it.
This is more of a myth that V8's are thirsty and V6's are economical. More depends on the net displacement, AFR, power and torque generation, load and above everything 'gearbox'.
These days there are technologies like VCM etc which make even the V6's and V8's run economically when driven with light foot and still provide the punch when driven with a heavy foot.
Only two such engines experienced till date; Accord V6 which a friend bought used and sold out in a time duration that was lesser than even the time he took to decide that he need to buy an Accord V6 and the second car I TDed(a couple of months back when we were searching for a premium UV for us) with V6 engine was an Audi Q5 3.0 V6 TDI, definitely it is one heck of an engine and delivers like nothing else can.
'V' type engines haven't actually gained popularity for the performance, but the actual reason behind the popularity of 'V' type engines is the compactness they offer. 'V' type engines are shorter in length and wider in width and hence they are easy to accommodate without increasing the length of the hood. Adding to that, being compact in length these engines also help in aiding dynamics too. If this was not enough, then these engines also offer an advantage of a more compact crankshaft - that's definitely an advantage for an high revving engine.
Rest there are engines like BMW 3.0 straight 6 and many other straight engines from Porsche etc which can beat their 'V' type counterparts up and down.