OP, beets provide nitrates. That’s their MoA. You can drink a ton of juice which is expensive, or take a ton of power, which is annoying and unstandardized. Or you can just use some potassium nitrate caps for probably under $0.25 a serving. Guaranteed potency of nitrate content. Why bother with something else here?
And don’t expect anything besides nitrates. So if nitrates don’t get you hyped up, because they’re not stimulants, then don’t expect them to replace caffeine.
Expect increased pumps and endurance. Any feelings you get would be secondary to a better pump and endurance; it’s not going to be stimulating, euphoric, mood enhancing at all in and of itself.