Ours is a big house but it's bottom heavy as we don't need many bedrooms.
We use all the downstairs rooms, two sitting rooms, study, dining room, kitchen and, here is the bonus, massive walk in larder and huge utility room for all the coats, boots, wellies. We have a second fridge and freezer in there as well as the washing machine and dryer, mops, brooms, cleaning stuff stored in cupboards, medicine cabinet, etc. It even has a ceiling drying rack on a pulley. These are probably the most useful rooms for storage, laundry, etc.
The bedrooms are all doubles with built in wardrobes so good sizes but not too much. Look for what suits your needs now and, if intending to stay long term, future needs. We plan to turn second sitting room into a bedroom if/when we are too old to manage stairs. We also have a bathroom with shower downstairs as well as up for the same reason.
If you have the funds, my priorities would be off road parking with a garage or store for bikes, garden equipment, bbq/camping stuff etc.
Detached houses can be very remote or just a few meters away from neighbours so again, it's whatever is your preference.
I would say if you don't need six bedrooms, don't buy six bedrooms. It's wasted space. There is so much variety out there so try to keep focus on how you live your life now and and how you will live in the house you choose.