The Joie 360 Spin is great in terms of price and it does have good safety and is well designed compared with the other more "budget" spin seats.
It doesn't typically last long enough for tall/chunky kids - this is less of an issue if you're planning to pass it down. You can move your first one into something like Axkid Move when the second is born, or when they outgrow this.
Some people find it hard to get a good fit from newborn. The inserts, and the pads on the straps are bulky and can be confusing. In theory, they provide a really great, gradual transition from a lot of support to less support. In practice it can be tricky to get the right combination.
The Joie i-Spin 360 is a little easier for this, but IMO the price jump is enough that it loses the budget "pro" and a lot of the cons start to outweigh this.
It doesn't have good leg room for rear facing because of the lack of a rebound bar. Most children look very scrunched up from about 2 years old. 18 months for taller children. Although it can rear face up to 18kg, the vast majority of people don't rear face that long in this seat. If rear facing is your goal, then you need to be quite committed to it to make it work in this seat. And OTOH if you aren't so fussed about rear facing all the way up to age 4, I don't think it's the best safety rating for a forward facing seat. However, again, this might not be such an issue if you are planning to pass it down, and you're just planning to use it like a longer-lasting first seat.
In terms of practicality of skipping the baby seat stage, it means that you get stuck in the car when they fall asleep. Whereas if you have a carry seat, you have the option to take it with you. You can transfer a baby from their car seat to something else e.g. a sling, a pushchair, some babies are fairly chilled and will go right back to sleep. Some babies are less tolerant of this and will wake up. Younger babies nap on and off all day, so you can get stuck in the car a bit with this which is a pain.
The other thing with skipping the carry seat is that if you have a baby who is still quite young over winter, this becomes a pain as you can't put bulky winter clothing on them in the car seat - it makes the straps too loose. It's easy when you can strap them into the carrier and then bundle blankets on top of them and then just pick the whole thing up and click or strap it into the car, compared to either faffing around with taking coats on and off or wrapping them in a blanket. This might be less of an issue if you have e.g. a connected garage. Thinking even if you have a summer due date, you want to reuse the seat for another child and they might be born in winter. This is an issue for anything from late summer babies right up to about April birthday. It's (maybe?) less of a problem for babies born March-June. But I know for example my August babies were still pretty tiny when it was freezing cold and rainy a lot of the time.
IMO the best multi-age seats for a good fit from newborn are:
Axkid One2 - you need the + version.
Avionaut Sky
Besafe izi Turn (or Twist) - you need the B version. This is especially good if you have sloping seats in your car, as most multi-age seats are too angled in this scenario.
Besafe Stretch - again B version.
And worth looking at:
Joie 360 Spin / i-Spin 360 - just for the cost factor but you need to be fairly confident to get a good newborn fit.
Recaro Salia Elite - has a carry out thing for the tiniest newborns but also converts to a full sized spin seat with a good safety rating. Worth a fit check in your car, as the angle is very steep in some cars, and the seat very high making it hard to fit the child through the door opening in some cars.
Britax seats - Dualfix or Max Space Pro - to be totally honest, I don't know what the newborn fit is like for these but some of the promo photos with newborns look good. One issue we had with Britax was that the stage where baby is too big for the newborn insert, but too small to use the seat without is awkward, so I recommend also getting (or at least bookmarking!) the "Britax Comfort Insert" for this in-between stage.
Cybex Sirona Gi i-size - for a combination of cost and I used to find the newborn insert great in GB Vaya, which is a sister company of Cybex, but TBH I haven't seen the insert in the new Sirona.
In terms of the usual argument of getting a carry seat first so you can see whether you need a 105cm/18kg limit for the next stage, vs a 25kg/125cm limit for the next stage, I think this is somewhat negated when you plan to hand the first seat down. Because if you have two tall children, fairly close in age then you are eventually going to need two seats in the middle stage (5 point harness / ERF stage). So it does actually make logical sense to opt for a 0-4 years (ish) seat which can be used from birth to maybe 2.5 / 3 (for the tallest children) rather than an infant carry seat which might be outgrown before a year old.
If you do decide to look at infant only/carry seats anyway, the Cybex ones tend to be the longest lasting. Ignore height limits, unless it's less than 80cm, physical size of the seat is more relevant. What you want to do is go into a shop, take a tape measure, measure the seats from the bottom where the baby's bum would go, right up to the shoulder height under the headrest or where the straps come out with straps/headrest in highest position. The longest one will last the longest. Check if there are newborn inserts under the cover to remove. Ask a shop assistant to help if you like (I once got this request and I was so happy to do it!)
Cybex Cloud tends to be good, and has a swivel base meaning it's practical to use it as an occasional carry type seat and leave in the car most of the time, but it does cost more than some of the 0-4 years types of seat. Cybex Aton S2 is a cheaper option which is I think similarly long lasting (check this).
Joie i-Level 2 is another good option again with swivel base option, slightly cheaper, still more than the most budget 0-4 years seats. Britax also tend to be larger in the shell, but I'm not up to date with the current models. Some of these have a swivel base too, but at a similar price point to Cybex.
Good luck, happy shopping! Happy to answer any further questions.