I think your over thinking this.So here's my question: Is the Vds limit related to how much of a given circuit's charge can be 'sunk into' the MOSFET rather than what voltage can be applied to the circuit in which the MOSFET appears? If so, is there a limit as to the voltage that can be applied to the entire circuit where the MOSFET appears, or is the voltage ceiling unlimited with tolerances only dependent on how much voltage is dropped across Drain-Source? If the circuit voltage is limited but the Vds limit isn't actually it, where do manufacturers specify this quantity?
The only thing "sunk into"(your terms) is the result of the Rds. The rest is just like it is going through a wire or other connection.
The Vds is limited inside the package of the device, something called the "die". A mosfet rated at higher value in the same package is only different inside by the size of the "die". The circuit voltage for the mosfet is specified in the data sheet by 'Vds'. And should be used conservatively, don't run it at the maximum value, electronic parts are always "derated".
That can be done but then your opening another can of worms that you aren't ready for.if we place another device on the circuit with it?