I’ve borrowed an upright Vax recently & it’s made a difference for sure, even pulling crap out of a part of the carpet we don’t use that much, which had been done with a good vacuum cleaner twice!
Takes some effort though, and you will find that if you pre-treat or do an area twice, you’ll get a much better result.
IMO it would be good if you can put some sort of scotchguard stuff back on it, coz I’m wondering if us cleaning our hallway carpet has stripped that off it as i’d swear it’s gotten noticeably dirtier quite soon afterwards…