Yes this will work 'as intended' with Steam - just create a new library on the external drive once its mounted. If the mount point changes (e.g. because you mount by block ID vs UUID) you may have to re-add it once it re-mounts. It should work fine with other games (not on Steam) as well, if you mount it somewhere you have read/write access to (or chown it). No requirement for USB 3 even - just a 'nice to have' for performance.
Note that you may not (as in, probably will not) be able to install the game 'once' - e.g. say you wanted to install Half-Life 2 in Windows, and also use it in Linux, it will generally need both the Windows and Linux version(s) of the game installed. This is kind of a weird corner-case (I can't imagine why you'd want two ports of the same installed), but the bigger takeway is expect to have two Steam libraries on separate partitions (also there's few file systems that are truly 'common' between Windows and Linux, as you point out).
All of this should also work with no problem for non-Steam games as well, for example those downloaded from GOG - the computer won't regard the external drive as 'special' in any way, its just another block device onto which it can write data. Just point the installer at whatever directory you create, and away you go (and this will apply in both Windows and Linux). The only thing to keep in mind - don't accidentally eject the USB drive (it won't hurt anything, you'll just lose the drive until you reconnect it) - in Windows this is probably easier to do by accident with the 'Safely Remove Hardware' prompt rolling all devices up into a menu, whereas most Linux DEs will show an eject icon per-device in their respective file managers.
https://support.steampowered.com/kb_...7418-YUBN-8129 (the GUI examples will apply in linux as well, but the device names will be different)
https://www.cyberciti.biz/faq/linux-...-update-fstab/ (this was the easiest guide I could find to setup fstab with UUID - its really quite simple, and will be more resilient than using the block ID (e.g. /dev/sda) especially when dealing with removable media)
Finally: you may not need an SSD for this role. Very few benchmarks show significant benefits for SSDs to gaming (I know this cuts counter to the 'conventional wisdom' of many online echo chambers), because most games are computationally bound, rather than disk bound (and modern mechanical hard drives have also gotten seriously fast to boot). Just food for thought if you're weighing cost/capacity - I'm not at all opposed to an SSD for an internal drive in a laptop (for a variety of reasons it's a good idea), but for an external game drive I'd probably be inclined to save my money and get a large-ish 3.5" external instead (then again, I also don't see how a single 2TB SSD is either 'cheap' or 'too small' even for a dual-booting system, so perhaps our use cases are quite dissimilar).